DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE dependencies on FND_FLEX_KEYVAL

Line 3966: l_valid_kff:= fnd_flex_keyval.validate_ccid(

3962: WHERE inventory_item_id = p_line_rec.inventory_item_id
3963: AND organization_id = l_organization_id;
3964:
3965: --bug 10047225
3966: l_valid_kff:= fnd_flex_keyval.validate_ccid(
3967: APPL_SHORT_NAME=>'INV',
3968: KEY_FLEX_CODE=>'MSTK',
3969: STRUCTURE_NUMBER=>101,
3970: COMBINATION_ID=>p_line_rec.inventory_item_id,

Line 3982: x_line_val_rec.ordered_item_dsp:= fnd_flex_keyval.concatenated_values;

3978: USER_ID=>NULL
3979: );
3980:
3981: if l_valid_kff then
3982: x_line_val_rec.ordered_item_dsp:= fnd_flex_keyval.concatenated_values;
3983: x_line_val_rec.inventory_item:= fnd_flex_keyval.concatenated_values;
3984:
3985: end if;
3986: --end of bug 10047225

Line 3983: x_line_val_rec.inventory_item:= fnd_flex_keyval.concatenated_values;

3979: );
3980:
3981: if l_valid_kff then
3982: x_line_val_rec.ordered_item_dsp:= fnd_flex_keyval.concatenated_values;
3983: x_line_val_rec.inventory_item:= fnd_flex_keyval.concatenated_values;
3984:
3985: end if;
3986: --end of bug 10047225
3987: IF l_debug_level > 0 THEN

Line 4026: l_valid_kff:= fnd_flex_keyval.validate_ccid(

4022: AND cxref.master_organization_id = mp.master_organization_id
4023: AND mp.organization_id = sitems.organization_id ; -- bug 3918771
4024:
4025: --bug 10047225
4026: l_valid_kff:= fnd_flex_keyval.validate_ccid(
4027: APPL_SHORT_NAME=>'INV',
4028: KEY_FLEX_CODE=>'MSTK',
4029: STRUCTURE_NUMBER=>101,
4030: COMBINATION_ID=>p_line_rec.inventory_item_id,

Line 4042: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;

4038: USER_ID=>NULL
4039: );
4040:
4041: if l_valid_kff then
4042: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;
4043:
4044: end if;
4045: --end of bug 10047225
4046: IF l_debug_level > 0 THEN

Line 4070: l_valid_kff:= fnd_flex_keyval.validate_ccid(

4066: WHERE inventory_item_id = p_line_rec.inventory_item_id
4067: AND organization_id = l_organization_id;
4068:
4069: --bug 10047225
4070: l_valid_kff:= fnd_flex_keyval.validate_ccid(
4071: APPL_SHORT_NAME=>'INV',
4072: KEY_FLEX_CODE=>'MSTK',
4073: STRUCTURE_NUMBER=>101,
4074: COMBINATION_ID=>p_line_rec.inventory_item_id,

Line 4086: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;

4082: USER_ID=>NULL
4083: );
4084:
4085: if l_valid_kff then
4086: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;
4087: end if;
4088: --end of bug 10047225
4089:
4090: IF l_debug_level > 0 THEN

Line 4129: l_valid_kff:= fnd_flex_keyval.validate_ccid(

4125: AND items.cross_reference_type = p_line_rec.item_identifier_type
4126: AND items.cross_reference = p_line_rec.ordered_item;
4127:
4128: --bug 10047225
4129: l_valid_kff:= fnd_flex_keyval.validate_ccid(
4130: APPL_SHORT_NAME=>'INV',
4131: KEY_FLEX_CODE=>'MSTK',
4132: STRUCTURE_NUMBER=>101,
4133: COMBINATION_ID=>p_line_rec.inventory_item_id,

Line 4145: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;

4141: USER_ID=>NULL
4142: );
4143:
4144: if l_valid_kff then
4145: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;
4146: end if;
4147: --end of bug 10047225
4148: IF l_debug_level > 0 THEN
4149: oe_debug_pub.add( 'DESCRIPTION: '||X_LINE_VAL_REC.ITEM_DESCRIPTION ) ;

Line 4173: l_valid_kff:= fnd_flex_keyval.validate_ccid(

4169: WHERE inventory_item_id = p_line_rec.inventory_item_id
4170: AND organization_id = l_organization_id;
4171:
4172: --bug 10047225
4173: l_valid_kff:= fnd_flex_keyval.validate_ccid(
4174: APPL_SHORT_NAME=>'INV',
4175: KEY_FLEX_CODE=>'MSTK',
4176: STRUCTURE_NUMBER=>101,
4177: COMBINATION_ID=>p_line_rec.inventory_item_id,

Line 4189: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;

4185: USER_ID=>NULL
4186: );
4187:
4188: if l_valid_kff then
4189: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;
4190: end if;
4191: --end of bug 10047225
4192:
4193: IF l_debug_level > 0 THEN

Line 4221: l_valid_kff:= fnd_flex_keyval.validate_ccid(

4217: AND items.cross_reference = p_line_rec.ordered_item
4218: AND items.org_independent_flag = 'Y' ;
4219:
4220: --bug 10047225
4221: l_valid_kff:= fnd_flex_keyval.validate_ccid(
4222: APPL_SHORT_NAME=>'INV',
4223: KEY_FLEX_CODE=>'MSTK',
4224: STRUCTURE_NUMBER=>101,
4225: COMBINATION_ID=>p_line_rec.inventory_item_id,

Line 4237: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;

4233: USER_ID=>NULL
4234: );
4235:
4236: if l_valid_kff then
4237: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;
4238: end if;
4239: --end of bug 10047225
4240: EXCEPTION
4241: WHEN No_Data_Found THEN

Line 4261: l_valid_kff:= fnd_flex_keyval.validate_ccid(

4257: AND items.cross_reference = p_line_rec.ordered_item
4258: AND items.organization_id = l_organization_id ;
4259:
4260: --bug 10047225
4261: l_valid_kff:= fnd_flex_keyval.validate_ccid(
4262: APPL_SHORT_NAME=>'INV',
4263: KEY_FLEX_CODE=>'MSTK',
4264: STRUCTURE_NUMBER=>101,
4265: COMBINATION_ID=>p_line_rec.inventory_item_id,

Line 4277: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;

4273: USER_ID=>NULL
4274: );
4275:
4276: if l_valid_kff then
4277: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;
4278: end if;
4279: --end of bug 10047225
4280: EXCEPTION
4281: WHEN No_Data_Found THEN

Line 4293: l_valid_kff:= fnd_flex_keyval.validate_ccid(

4289: FROM mtl_system_items_vl
4290: WHERE inventory_item_id = p_line_rec.inventory_item_id
4291: AND organization_id = l_organization_id;
4292: --bug 10047225
4293: l_valid_kff:= fnd_flex_keyval.validate_ccid(
4294: APPL_SHORT_NAME=>'INV',
4295: KEY_FLEX_CODE=>'MSTK',
4296: STRUCTURE_NUMBER=>101,
4297: COMBINATION_ID=>p_line_rec.inventory_item_id,

Line 4309: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;

4305: USER_ID=>NULL
4306: );
4307:
4308: if l_valid_kff then
4309: x_line_val_rec.inventory_item := fnd_flex_keyval.concatenated_values;
4310: end if;
4311: --end of bug 10047225
4312: END IF ;
4313: When Others then

Line 6537: l_valid_kff := fnd_flex_keyval.validate_ccid(

6533: IF NVL(p_item_identifier_type, 'INT') = 'INT' THEN
6534:
6535: BEGIN
6536: --bug 10047225
6537: l_valid_kff := fnd_flex_keyval.validate_ccid(
6538: APPL_SHORT_NAME=>'INV',
6539: KEY_FLEX_CODE=>'MSTK',
6540: STRUCTURE_NUMBER=>101,
6541: COMBINATION_ID=>p_inventory_item_id,

Line 6554: x_ordered_item:= fnd_flex_keyval.concatenated_values;

6550: );
6551:
6552: if l_valid_kff then
6553: oe_debug_pub.add('10047225: Proc GET_ORDERED_ITEM:l_valid_kff: TRUE');
6554: x_ordered_item:= fnd_flex_keyval.concatenated_values;
6555:
6556: end if;
6557: oe_debug_pub.add('10047225:Proc GET_ORDERED_ITEM: x_ordered_item:'||x_ordered_item);
6558: --end of bug 10047225