eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_DEFAULT_RES dependencies on FND_API

Line 28: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;

24: /* Private Procedure that will populate all the attributes from RCV_TRANSACTIONS_INTERFACE. Populating each attribute individually will be a performance hit, so call this procedure once */
25: PROCEDURE get_rti_attr
26: IS
27:
28: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
29: l_wip_line_id NUMBER := FND_API.G_MISS_NUM;
30: l_wip_repetitive_schedule_id NUMBER := FND_API.G_MISS_NUM;
31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;

Line 29: l_wip_line_id NUMBER := FND_API.G_MISS_NUM;

25: PROCEDURE get_rti_attr
26: IS
27:
28: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
29: l_wip_line_id NUMBER := FND_API.G_MISS_NUM;
30: l_wip_repetitive_schedule_id NUMBER := FND_API.G_MISS_NUM;
31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;
33: l_transaction_date DATE := FND_API.G_MISS_DATE;

Line 30: l_wip_repetitive_schedule_id NUMBER := FND_API.G_MISS_NUM;

26: IS
27:
28: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
29: l_wip_line_id NUMBER := FND_API.G_MISS_NUM;
30: l_wip_repetitive_schedule_id NUMBER := FND_API.G_MISS_NUM;
31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;
33: l_transaction_date DATE := FND_API.G_MISS_DATE;
34: l_creation_date DATE := FND_API.G_MISS_DATE;

Line 31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;

27:
28: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
29: l_wip_line_id NUMBER := FND_API.G_MISS_NUM;
30: l_wip_repetitive_schedule_id NUMBER := FND_API.G_MISS_NUM;
31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;
33: l_transaction_date DATE := FND_API.G_MISS_DATE;
34: l_creation_date DATE := FND_API.G_MISS_DATE;
35: l_created_by NUMBER := FND_API.G_MISS_NUM;

Line 32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;

28: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
29: l_wip_line_id NUMBER := FND_API.G_MISS_NUM;
30: l_wip_repetitive_schedule_id NUMBER := FND_API.G_MISS_NUM;
31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;
33: l_transaction_date DATE := FND_API.G_MISS_DATE;
34: l_creation_date DATE := FND_API.G_MISS_DATE;
35: l_created_by NUMBER := FND_API.G_MISS_NUM;
36: l_item_id NUMBER := FND_API.G_MISS_NUM;

Line 33: l_transaction_date DATE := FND_API.G_MISS_DATE;

29: l_wip_line_id NUMBER := FND_API.G_MISS_NUM;
30: l_wip_repetitive_schedule_id NUMBER := FND_API.G_MISS_NUM;
31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;
33: l_transaction_date DATE := FND_API.G_MISS_DATE;
34: l_creation_date DATE := FND_API.G_MISS_DATE;
35: l_created_by NUMBER := FND_API.G_MISS_NUM;
36: l_item_id NUMBER := FND_API.G_MISS_NUM;
37: l_last_update_date DATE := FND_API.G_MISS_DATE;

Line 34: l_creation_date DATE := FND_API.G_MISS_DATE;

30: l_wip_repetitive_schedule_id NUMBER := FND_API.G_MISS_NUM;
31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;
33: l_transaction_date DATE := FND_API.G_MISS_DATE;
34: l_creation_date DATE := FND_API.G_MISS_DATE;
35: l_created_by NUMBER := FND_API.G_MISS_NUM;
36: l_item_id NUMBER := FND_API.G_MISS_NUM;
37: l_last_update_date DATE := FND_API.G_MISS_DATE;
38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;

Line 35: l_created_by NUMBER := FND_API.G_MISS_NUM;

31: l_wip_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;
33: l_transaction_date DATE := FND_API.G_MISS_DATE;
34: l_creation_date DATE := FND_API.G_MISS_DATE;
35: l_created_by NUMBER := FND_API.G_MISS_NUM;
36: l_item_id NUMBER := FND_API.G_MISS_NUM;
37: l_last_update_date DATE := FND_API.G_MISS_DATE;
38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;
39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;

Line 36: l_item_id NUMBER := FND_API.G_MISS_NUM;

32: l_wip_resource_seq_num NUMBER := FND_API.G_MISS_NUM;
33: l_transaction_date DATE := FND_API.G_MISS_DATE;
34: l_creation_date DATE := FND_API.G_MISS_DATE;
35: l_created_by NUMBER := FND_API.G_MISS_NUM;
36: l_item_id NUMBER := FND_API.G_MISS_NUM;
37: l_last_update_date DATE := FND_API.G_MISS_DATE;
38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;
39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;
40: l_organization_id NUMBER := FND_API.G_MISS_NUM;

Line 37: l_last_update_date DATE := FND_API.G_MISS_DATE;

33: l_transaction_date DATE := FND_API.G_MISS_DATE;
34: l_creation_date DATE := FND_API.G_MISS_DATE;
35: l_created_by NUMBER := FND_API.G_MISS_NUM;
36: l_item_id NUMBER := FND_API.G_MISS_NUM;
37: l_last_update_date DATE := FND_API.G_MISS_DATE;
38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;
39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;
40: l_organization_id NUMBER := FND_API.G_MISS_NUM;
41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;

Line 38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;

34: l_creation_date DATE := FND_API.G_MISS_DATE;
35: l_created_by NUMBER := FND_API.G_MISS_NUM;
36: l_item_id NUMBER := FND_API.G_MISS_NUM;
37: l_last_update_date DATE := FND_API.G_MISS_DATE;
38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;
39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;
40: l_organization_id NUMBER := FND_API.G_MISS_NUM;
41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
42: l_reason_id NUMBER := FND_API.G_MISS_NUM;

Line 39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;

35: l_created_by NUMBER := FND_API.G_MISS_NUM;
36: l_item_id NUMBER := FND_API.G_MISS_NUM;
37: l_last_update_date DATE := FND_API.G_MISS_DATE;
38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;
39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;
40: l_organization_id NUMBER := FND_API.G_MISS_NUM;
41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
42: l_reason_id NUMBER := FND_API.G_MISS_NUM;
43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;

Line 40: l_organization_id NUMBER := FND_API.G_MISS_NUM;

36: l_item_id NUMBER := FND_API.G_MISS_NUM;
37: l_last_update_date DATE := FND_API.G_MISS_DATE;
38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;
39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;
40: l_organization_id NUMBER := FND_API.G_MISS_NUM;
41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
42: l_reason_id NUMBER := FND_API.G_MISS_NUM;
43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;
44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;

Line 41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;

37: l_last_update_date DATE := FND_API.G_MISS_DATE;
38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;
39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;
40: l_organization_id NUMBER := FND_API.G_MISS_NUM;
41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
42: l_reason_id NUMBER := FND_API.G_MISS_NUM;
43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;
44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;

Line 42: l_reason_id NUMBER := FND_API.G_MISS_NUM;

38: l_last_updated_by NUMBER := FND_API.G_MISS_NUM;
39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;
40: l_organization_id NUMBER := FND_API.G_MISS_NUM;
41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
42: l_reason_id NUMBER := FND_API.G_MISS_NUM;
43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;
44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;
46: l_quantity NUMBER := FND_API.G_MISS_NUM;

Line 43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;

39: l_last_update_login NUMBER := FND_API.G_MISS_NUM;
40: l_organization_id NUMBER := FND_API.G_MISS_NUM;
41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
42: l_reason_id NUMBER := FND_API.G_MISS_NUM;
43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;
44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;
46: l_quantity NUMBER := FND_API.G_MISS_NUM;
47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;

Line 44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;

40: l_organization_id NUMBER := FND_API.G_MISS_NUM;
41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
42: l_reason_id NUMBER := FND_API.G_MISS_NUM;
43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;
44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;
46: l_quantity NUMBER := FND_API.G_MISS_NUM;
47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;

Line 45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;

41: l_primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
42: l_reason_id NUMBER := FND_API.G_MISS_NUM;
43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;
44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;
46: l_quantity NUMBER := FND_API.G_MISS_NUM;
47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;
49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;

Line 46: l_quantity NUMBER := FND_API.G_MISS_NUM;

42: l_reason_id NUMBER := FND_API.G_MISS_NUM;
43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;
44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;
46: l_quantity NUMBER := FND_API.G_MISS_NUM;
47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;
49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;
50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;

Line 47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;

43: l_source_doc_quantity NUMBER := FND_API.G_MISS_NUM;
44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;
46: l_quantity NUMBER := FND_API.G_MISS_NUM;
47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;
49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;
50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;
51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;

Line 48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;

44: l_source_doc_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;
46: l_quantity NUMBER := FND_API.G_MISS_NUM;
47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;
49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;
50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;
51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;
52: l_currency_conversion_type VARCHAR2(10) := FND_API.G_MISS_CHAR;

Line 49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;

45: l_comments VARCHAR2(240) := FND_API.G_MISS_CHAR;
46: l_quantity NUMBER := FND_API.G_MISS_NUM;
47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;
49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;
50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;
51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;
52: l_currency_conversion_type VARCHAR2(10) := FND_API.G_MISS_CHAR;
53: l_currency_conversion_rate NUMBER := FND_API.G_MISS_NUM;

Line 50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;

46: l_quantity NUMBER := FND_API.G_MISS_NUM;
47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;
49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;
50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;
51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;
52: l_currency_conversion_type VARCHAR2(10) := FND_API.G_MISS_CHAR;
53: l_currency_conversion_rate NUMBER := FND_API.G_MISS_NUM;
54: l_currency_conversion_date DATE := FND_API.G_MISS_DATE;

Line 51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;

47: l_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR;
48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;
49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;
50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;
51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;
52: l_currency_conversion_type VARCHAR2(10) := FND_API.G_MISS_CHAR;
53: l_currency_conversion_rate NUMBER := FND_API.G_MISS_NUM;
54: l_currency_conversion_date DATE := FND_API.G_MISS_DATE;
55: BEGIN

Line 52: l_currency_conversion_type VARCHAR2(10) := FND_API.G_MISS_CHAR;

48: l_po_header_id NUMBER := FND_API.G_MISS_NUM;
49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;
50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;
51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;
52: l_currency_conversion_type VARCHAR2(10) := FND_API.G_MISS_CHAR;
53: l_currency_conversion_rate NUMBER := FND_API.G_MISS_NUM;
54: l_currency_conversion_date DATE := FND_API.G_MISS_DATE;
55: BEGIN
56:

Line 53: l_currency_conversion_rate NUMBER := FND_API.G_MISS_NUM;

49: l_po_line_id NUMBER := FND_API.G_MISS_NUM;
50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;
51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;
52: l_currency_conversion_type VARCHAR2(10) := FND_API.G_MISS_CHAR;
53: l_currency_conversion_rate NUMBER := FND_API.G_MISS_NUM;
54: l_currency_conversion_date DATE := FND_API.G_MISS_DATE;
55: BEGIN
56:
57: IF g_Res_rec.source_code = 'RCV'

Line 54: l_currency_conversion_date DATE := FND_API.G_MISS_DATE;

50: l_po_unit_price NUMBER := FND_API.G_MISS_NUM;
51: l_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR;
52: l_currency_conversion_type VARCHAR2(10) := FND_API.G_MISS_CHAR;
53: l_currency_conversion_rate NUMBER := FND_API.G_MISS_NUM;
54: l_currency_conversion_date DATE := FND_API.G_MISS_DATE;
55: BEGIN
56:
57: IF g_Res_rec.source_code = 'RCV'
58: AND g_Res_rec.source_line_id IS NOT NULL THEN

Line 210: l_activity_id NUMBER := FND_API.G_MISS_NUM;

206: /* Private Procedure that will populate all the attributes from WIP_OPERATION_RESOURCES. Populating each attribute individually will be a performance hit, so call this procedure in all the attributes it populates. */
207:
208: PROCEDURE get_wor_attr
209: IS
210: l_activity_id NUMBER := FND_API.G_MISS_NUM;
211: l_resource_id NUMBER := FND_API.G_MISS_NUM;
212: l_usage_rate_or_amount NUMBER := FND_API.G_MISS_NUM;
213: l_basis_type NUMBER := FND_API.G_MISS_NUM;
214: l_autocharge_type NUMBER := FND_API.G_MISS_NUM;

Line 211: l_resource_id NUMBER := FND_API.G_MISS_NUM;

207:
208: PROCEDURE get_wor_attr
209: IS
210: l_activity_id NUMBER := FND_API.G_MISS_NUM;
211: l_resource_id NUMBER := FND_API.G_MISS_NUM;
212: l_usage_rate_or_amount NUMBER := FND_API.G_MISS_NUM;
213: l_basis_type NUMBER := FND_API.G_MISS_NUM;
214: l_autocharge_type NUMBER := FND_API.G_MISS_NUM;
215: l_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR;

Line 212: l_usage_rate_or_amount NUMBER := FND_API.G_MISS_NUM;

208: PROCEDURE get_wor_attr
209: IS
210: l_activity_id NUMBER := FND_API.G_MISS_NUM;
211: l_resource_id NUMBER := FND_API.G_MISS_NUM;
212: l_usage_rate_or_amount NUMBER := FND_API.G_MISS_NUM;
213: l_basis_type NUMBER := FND_API.G_MISS_NUM;
214: l_autocharge_type NUMBER := FND_API.G_MISS_NUM;
215: l_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR;
216: l_std_rate_flag NUMBER := FND_API.G_MISS_NUM;

Line 213: l_basis_type NUMBER := FND_API.G_MISS_NUM;

209: IS
210: l_activity_id NUMBER := FND_API.G_MISS_NUM;
211: l_resource_id NUMBER := FND_API.G_MISS_NUM;
212: l_usage_rate_or_amount NUMBER := FND_API.G_MISS_NUM;
213: l_basis_type NUMBER := FND_API.G_MISS_NUM;
214: l_autocharge_type NUMBER := FND_API.G_MISS_NUM;
215: l_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR;
216: l_std_rate_flag NUMBER := FND_API.G_MISS_NUM;
217:

Line 214: l_autocharge_type NUMBER := FND_API.G_MISS_NUM;

210: l_activity_id NUMBER := FND_API.G_MISS_NUM;
211: l_resource_id NUMBER := FND_API.G_MISS_NUM;
212: l_usage_rate_or_amount NUMBER := FND_API.G_MISS_NUM;
213: l_basis_type NUMBER := FND_API.G_MISS_NUM;
214: l_autocharge_type NUMBER := FND_API.G_MISS_NUM;
215: l_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR;
216: l_std_rate_flag NUMBER := FND_API.G_MISS_NUM;
217:
218: BEGIN

Line 215: l_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR;

211: l_resource_id NUMBER := FND_API.G_MISS_NUM;
212: l_usage_rate_or_amount NUMBER := FND_API.G_MISS_NUM;
213: l_basis_type NUMBER := FND_API.G_MISS_NUM;
214: l_autocharge_type NUMBER := FND_API.G_MISS_NUM;
215: l_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR;
216: l_std_rate_flag NUMBER := FND_API.G_MISS_NUM;
217:
218: BEGIN
219:

Line 216: l_std_rate_flag NUMBER := FND_API.G_MISS_NUM;

212: l_usage_rate_or_amount NUMBER := FND_API.G_MISS_NUM;
213: l_basis_type NUMBER := FND_API.G_MISS_NUM;
214: l_autocharge_type NUMBER := FND_API.G_MISS_NUM;
215: l_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR;
216: l_std_rate_flag NUMBER := FND_API.G_MISS_NUM;
217:
218: BEGIN
219:
220: IF g_Res_rec.wip_entity_id IS NOT NULL

Line 300: l_project_id NUMBER := FND_API.G_MISS_NUM;

296:
297:
298: PROCEDURE get_pd_attr
299: IS
300: l_project_id NUMBER := FND_API.G_MISS_NUM;
301: l_task_id NUMBER := FND_API.G_MISS_NUM;
302: l_nonrecoverable_tax NUMBER := FND_API.G_MISS_NUM;
303: l_quantity_ordered NUMBER := FND_API.G_MISS_NUM;
304: l_po_uom VARCHAR2(25) := FND_API.G_MISS_CHAR;

Line 301: l_task_id NUMBER := FND_API.G_MISS_NUM;

297:
298: PROCEDURE get_pd_attr
299: IS
300: l_project_id NUMBER := FND_API.G_MISS_NUM;
301: l_task_id NUMBER := FND_API.G_MISS_NUM;
302: l_nonrecoverable_tax NUMBER := FND_API.G_MISS_NUM;
303: l_quantity_ordered NUMBER := FND_API.G_MISS_NUM;
304: l_po_uom VARCHAR2(25) := FND_API.G_MISS_CHAR;
305: BEGIN

Line 302: l_nonrecoverable_tax NUMBER := FND_API.G_MISS_NUM;

298: PROCEDURE get_pd_attr
299: IS
300: l_project_id NUMBER := FND_API.G_MISS_NUM;
301: l_task_id NUMBER := FND_API.G_MISS_NUM;
302: l_nonrecoverable_tax NUMBER := FND_API.G_MISS_NUM;
303: l_quantity_ordered NUMBER := FND_API.G_MISS_NUM;
304: l_po_uom VARCHAR2(25) := FND_API.G_MISS_CHAR;
305: BEGIN
306:

Line 303: l_quantity_ordered NUMBER := FND_API.G_MISS_NUM;

299: IS
300: l_project_id NUMBER := FND_API.G_MISS_NUM;
301: l_task_id NUMBER := FND_API.G_MISS_NUM;
302: l_nonrecoverable_tax NUMBER := FND_API.G_MISS_NUM;
303: l_quantity_ordered NUMBER := FND_API.G_MISS_NUM;
304: l_po_uom VARCHAR2(25) := FND_API.G_MISS_CHAR;
305: BEGIN
306:
307: IF g_Res_rec.source_code = 'RCV'

Line 304: l_po_uom VARCHAR2(25) := FND_API.G_MISS_CHAR;

300: l_project_id NUMBER := FND_API.G_MISS_NUM;
301: l_task_id NUMBER := FND_API.G_MISS_NUM;
302: l_nonrecoverable_tax NUMBER := FND_API.G_MISS_NUM;
303: l_quantity_ordered NUMBER := FND_API.G_MISS_NUM;
304: l_po_uom VARCHAR2(25) := FND_API.G_MISS_CHAR;
305: BEGIN
306:
307: IF g_Res_rec.source_code = 'RCV'
308: AND g_Res_rec.source_line_id IS NOT NULL THEN

Line 371: l_resource_code VARCHAR2(10) := FND_API.G_MISS_CHAR;

367: END get_pd_attr;
368:
369: PROCEDURE get_br_attr
370: IS
371: l_resource_code VARCHAR2(10) := FND_API.G_MISS_CHAR;
372: l_resource_type NUMBER := FND_API.G_MISS_NUM;
373: BEGIN
374:
375: IF g_Res_rec.resource_id IS NOT NULL THEN

Line 372: l_resource_type NUMBER := FND_API.G_MISS_NUM;

368:
369: PROCEDURE get_br_attr
370: IS
371: l_resource_code VARCHAR2(10) := FND_API.G_MISS_CHAR;
372: l_resource_type NUMBER := FND_API.G_MISS_NUM;
373: BEGIN
374:
375: IF g_Res_rec.resource_id IS NOT NULL THEN
376:

Line 441: RETURN FND_API.G_MISS_NUM;

437: RETURN NULL;
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: RETURN FND_API.G_MISS_NUM;
442:
443: END Get_Acct_Period;
444:
445: FUNCTION Get_Activity

Line 448: l_activity_id NUMBER := FND_API.G_MISS_NUM;

444:
445: FUNCTION Get_Activity
446: RETURN NUMBER
447: IS
448: l_activity_id NUMBER := FND_API.G_MISS_NUM;
449: BEGIN
450:
451: IF g_Res_rec.activity_id IS NOT NULL THEN
452: RETURN g_Res_rec.activity_id;

Line 466: RETURN FND_API.G_MISS_NUM;

462: RETURN NULL;
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: RETURN FND_API.G_MISS_NUM;
467:
468: END Get_Activity;
469:
470: FUNCTION Get_Activity_Name

Line 493: RETURN FND_API.G_MISS_CHAR;

489: RETURN NULL;
490:
491: EXCEPTION
492: WHEN OTHERS THEN
493: RETURN FND_API.G_MISS_CHAR;
494:
495: END Get_Activity_Name;
496:
497: FUNCTION Get_Actual_Resource_Rate

Line 500: l_actual_resource_rate NUMBER := FND_API.G_MISS_NUM;

496:
497: FUNCTION Get_Actual_Resource_Rate
498: RETURN NUMBER
499: IS
500: l_actual_resource_rate NUMBER := FND_API.G_MISS_NUM;
501: l_uom_basis VARCHAR2(25);
502: l_uom_code VARCHAR2(3);
503: l_po_uom VARCHAR2(25) ;
504: l_po_unit_price NUMBER;

Line 572: RETURN FND_API.G_MISS_NUM;

568:
569: /* return null when inv_um_convert can't convert */
570:
571: if l_conversion_factor = -99999 then
572: RETURN FND_API.G_MISS_NUM;
573: end if ;
574:
575: l_po_unit_price := g_RCV_txn.po_unit_price * l_conversion_factor ;
576:

Line 658: RETURN FND_API.G_MISS_NUM;

654: RETURN NULL;
655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: RETURN FND_API.G_MISS_NUM;
659:
660: END Get_Actual_Resource_Rate;
661:
662: FUNCTION Get_Autocharge_Type

Line 684: RETURN FND_API.G_MISS_NUM;

680: END IF;
681:
682: EXCEPTION
683: WHEN OTHERS THEN
684: RETURN FND_API.G_MISS_NUM;
685:
686: END Get_Autocharge_Type;
687:
688: FUNCTION Get_Basis_Type

Line 706: RETURN FND_API.G_MISS_NUM;

702: END IF;
703:
704: EXCEPTION
705: WHEN OTHERS THEN
706: RETURN FND_API.G_MISS_NUM;
707:
708: END Get_Basis_Type;
709:
710: FUNCTION Get_Completion_Transaction

Line 723: RETURN FND_API.G_MISS_NUM;

719: RETURN NULL;
720:
721: EXCEPTION
722: WHEN OTHERS THEN
723: RETURN FND_API.G_MISS_NUM;
724:
725: END Get_Completion_Transaction;
726:
727: FUNCTION Get_Created_By

Line 752: RETURN FND_API.G_MISS_CHAR;

748: RETURN fnd_global.user_id ;
749:
750: EXCEPTION
751: WHEN OTHERS THEN
752: RETURN FND_API.G_MISS_CHAR;
753:
754: END Get_Created_By;
755:
756:

Line 779: RETURN FND_API.G_MISS_CHAR;

775: RETURN NULL;
776:
777: EXCEPTION
778: WHEN OTHERS THEN
779: RETURN FND_API.G_MISS_CHAR;
780:
781: END Get_Created_By_Name;
782:
783: FUNCTION Get_Creation_Date

Line 808: RETURN FND_API.G_MISS_DATE;

804: RETURN sysdate ;
805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: RETURN FND_API.G_MISS_DATE;
809:
810: END Get_Creation_Date;
811:
812:

Line 840: RETURN FND_API.G_MISS_NUM;

836: RETURN NULL;
837:
838: EXCEPTION
839: WHEN OTHERS THEN
840: RETURN FND_API.G_MISS_NUM;
841:
842: END Get_Currency_Actual_Rsc_Rate;
843:
844: FUNCTION Get_Currency

Line 870: RETURN FND_API.G_MISS_NUM;

866: RETURN NULL;
867:
868: EXCEPTION
869: WHEN OTHERS THEN
870: RETURN FND_API.G_MISS_NUM;
871:
872: END Get_Currency;
873:
874: FUNCTION Get_Currency_Conversion_Date

Line 899: RETURN FND_API.G_MISS_DATE;

895: RETURN NULL;
896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: RETURN FND_API.G_MISS_DATE;
900: END Get_Currency_Conversion_Date;
901:
902: FUNCTION Get_Currency_Conversion_Rate
903: RETURN NUMBER

Line 927: RETURN FND_API.G_MISS_NUM;

923: RETURN NULL;
924:
925: EXCEPTION
926: WHEN OTHERS THEN
927: RETURN FND_API.G_MISS_NUM;
928:
929: END Get_Currency_Conversion_Rate;
930:
931: FUNCTION Get_Currency_Conversion_Type

Line 956: RETURN FND_API.G_MISS_NUM;

952: RETURN NULL;
953:
954: EXCEPTION
955: WHEN OTHERS THEN
956: RETURN FND_API.G_MISS_NUM;
957:
958: END Get_Currency_Conversion_Type;
959:
960: FUNCTION Get_Department_Code

Line 984: RETURN FND_API.G_MISS_CHAR;

980: RETURN NULL;
981:
982: EXCEPTION
983: WHEN OTHERS THEN
984: RETURN FND_API.G_MISS_CHAR;
985:
986: END Get_Department_Code;
987:
988: FUNCTION Get_Department_Id

Line 1017: RETURN FND_API.G_MISS_NUM;

1013: RETURN NULL;
1014:
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: RETURN FND_API.G_MISS_NUM;
1018:
1019: END Get_Department_Id;
1020:
1021: FUNCTION Get_Employee

Line 1034: RETURN FND_API.G_MISS_NUM;

1030: RETURN NULL;
1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: RETURN FND_API.G_MISS_NUM;
1035:
1036: END Get_Employee;
1037:
1038: FUNCTION Get_Employee_Num

Line 1051: RETURN FND_API.G_MISS_CHAR;

1047: RETURN NULL;
1048:
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: RETURN FND_API.G_MISS_CHAR;
1052:
1053: END Get_Employee_Num;
1054:
1055: FUNCTION Get_Entity_Type

Line 1075: RETURN FND_API.G_MISS_NUM;

1071: RETURN NULL;
1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: RETURN FND_API.G_MISS_NUM;
1076:
1077: END Get_Entity_Type;
1078:
1079: FUNCTION Get_Group

Line 1092: RETURN FND_API.G_MISS_NUM;

1088: RETURN NULL;
1089:
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: RETURN FND_API.G_MISS_NUM;
1093:
1094: END Get_Group;
1095:
1096: FUNCTION Get_Last_Updated_By

Line 1121: RETURN FND_API.G_MISS_CHAR;

1117: RETURN fnd_global.user_id ;
1118:
1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: RETURN FND_API.G_MISS_CHAR;
1122:
1123: END Get_Last_Updated_By;
1124:
1125: FUNCTION Get_Last_Updated_By_Name

Line 1147: RETURN FND_API.G_MISS_CHAR;

1143: RETURN NULL;
1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: RETURN FND_API.G_MISS_CHAR;
1148:
1149: END Get_Last_Updated_By_Name;
1150:
1151: FUNCTION Get_Last_Update_Date

Line 1176: RETURN FND_API.G_MISS_CHAR;

1172: RETURN sysdate ;
1173:
1174: EXCEPTION
1175: WHEN OTHERS THEN
1176: RETURN FND_API.G_MISS_CHAR;
1177:
1178: END Get_Last_Update_Date;
1179:
1180:

Line 1206: RETURN FND_API.G_MISS_CHAR;

1202: RETURN NULL;
1203:
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: RETURN FND_API.G_MISS_CHAR;
1207:
1208: END Get_Line_Code;
1209:
1210: FUNCTION Get_Line_Id

Line 1235: RETURN FND_API.G_MISS_NUM;

1231: RETURN NULL;
1232:
1233: EXCEPTION
1234: WHEN OTHERS THEN
1235: RETURN FND_API.G_MISS_NUM;
1236:
1237: END Get_Line_Id;
1238:
1239: FUNCTION Get_Move_Transaction

Line 1252: RETURN FND_API.G_MISS_NUM;

1248: RETURN NULL;
1249:
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: RETURN FND_API.G_MISS_NUM;
1253:
1254: END Get_Move_Transaction;
1255:
1256: FUNCTION Get_Operation_Seq_Num

Line 1281: RETURN FND_API.G_MISS_NUM;

1277: RETURN NULL;
1278:
1279: EXCEPTION
1280: WHEN OTHERS THEN
1281: RETURN FND_API.G_MISS_NUM;
1282:
1283: END Get_Operation_Seq_Num;
1284:
1285: FUNCTION Get_Organization_Code

Line 1307: RETURN FND_API.G_MISS_CHAR;

1303: RETURN NULL;
1304:
1305: EXCEPTION
1306: WHEN OTHERS THEN
1307: RETURN FND_API.G_MISS_CHAR;
1308:
1309: END Get_Organization_Code;
1310:
1311: FUNCTION Get_Organization_Id

Line 1336: RETURN FND_API.G_MISS_NUM;

1332: RETURN NULL;
1333:
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: RETURN FND_API.G_MISS_NUM;
1337:
1338: END Get_Organization_Id;
1339:
1340: FUNCTION Get_Po_Header

Line 1365: RETURN FND_API.G_MISS_NUM;

1361: RETURN NULL;
1362:
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: RETURN FND_API.G_MISS_NUM;
1366:
1367: END Get_Po_Header;
1368:
1369: FUNCTION Get_Po_Line

Line 1394: RETURN FND_API.G_MISS_NUM;

1390: RETURN NULL;
1391:
1392: EXCEPTION
1393: WHEN OTHERS THEN
1394: RETURN FND_API.G_MISS_NUM;
1395:
1396: END Get_Po_Line;
1397:
1398: FUNCTION Get_Primary_Item

Line 1418: RETURN FND_API.G_MISS_NUM;

1414: RETURN NULL;
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: RETURN FND_API.G_MISS_NUM;
1419:
1420: END Get_Primary_Item;
1421:
1422: FUNCTION Get_Primary_Quantity

Line 1439: RETURN FND_API.G_MISS_NUM;

1435: RETURN NULL;
1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: RETURN FND_API.G_MISS_NUM;
1440:
1441: END Get_Primary_Quantity;
1442:
1443: FUNCTION Get_Primary_Uom

Line 1463: RETURN FND_API.G_MISS_CHAR;

1459: RETURN NULL;
1460:
1461: EXCEPTION
1462: WHEN OTHERS THEN
1463: RETURN FND_API.G_MISS_CHAR;
1464:
1465: END Get_Primary_Uom;
1466:
1467: FUNCTION Get_Primary_Uom_Class

Line 1480: RETURN FND_API.G_MISS_CHAR;

1476: RETURN NULL;
1477:
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: RETURN FND_API.G_MISS_CHAR;
1481:
1482: END Get_Primary_Uom_Class;
1483:
1484: FUNCTION Get_Process_Phase

Line 1509: RETURN FND_API.G_MISS_NUM;

1505: RETURN NULL;
1506:
1507: EXCEPTION
1508: WHEN OTHERS THEN
1509: RETURN FND_API.G_MISS_NUM;
1510:
1511: END Get_Process_Phase;
1512:
1513: FUNCTION Get_Process_Status

Line 1537: RETURN FND_API.G_MISS_NUM;

1533: RETURN NULL;
1534:
1535: EXCEPTION
1536: WHEN OTHERS THEN
1537: RETURN FND_API.G_MISS_NUM;
1538:
1539: END Get_Process_Status;
1540:
1541: FUNCTION Get_Project

Line 1566: RETURN FND_API.G_MISS_NUM;

1562: RETURN NULL;
1563:
1564: EXCEPTION
1565: WHEN OTHERS THEN
1566: RETURN FND_API.G_MISS_NUM;
1567:
1568: END Get_Project;
1569:
1570: FUNCTION Get_Rcv_Transaction

Line 1583: RETURN FND_API.G_MISS_NUM;

1579: RETURN NULL;
1580:
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: RETURN FND_API.G_MISS_NUM;
1584:
1585: END Get_Rcv_Transaction;
1586:
1587: FUNCTION Get_Reason

Line 1612: RETURN FND_API.G_MISS_NUM;

1608: RETURN NULL;
1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: RETURN FND_API.G_MISS_NUM;
1613:
1614: END Get_Reason;
1615:
1616: FUNCTION Get_Reason_Name

Line 1640: RETURN FND_API.G_MISS_CHAR;

1636: RETURN NULL;
1637:
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: RETURN FND_API.G_MISS_CHAR;
1641:
1642: END Get_Reason_Name;
1643:
1644: FUNCTION Get_Receiving_Account

Line 1668: RETURN FND_API.G_MISS_NUM;

1664: RETURN NULL;
1665:
1666: EXCEPTION
1667: WHEN OTHERS THEN
1668: RETURN FND_API.G_MISS_NUM;
1669:
1670: END Get_Receiving_Account;
1671:
1672: FUNCTION Get_Reference

Line 1697: RETURN FND_API.G_MISS_CHAR;

1693: RETURN NULL;
1694:
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: RETURN FND_API.G_MISS_CHAR;
1698:
1699: END Get_Reference;
1700:
1701: FUNCTION Get_Repetitive_Schedule

Line 1726: RETURN FND_API.G_MISS_NUM;

1722: RETURN NULL;
1723:
1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: RETURN FND_API.G_MISS_NUM;
1727:
1728: END Get_Repetitive_Schedule;
1729:
1730: FUNCTION Get_Resource_Code

Line 1752: RETURN FND_API.G_MISS_CHAR;

1748: RETURN NULL;
1749:
1750: EXCEPTION
1751: WHEN OTHERS THEN
1752: RETURN FND_API.G_MISS_CHAR;
1753:
1754: END Get_Resource_Code;
1755:
1756: FUNCTION Get_Resource_Id

Line 1776: RETURN FND_API.G_MISS_NUM;

1772: RETURN NULL;
1773:
1774: EXCEPTION
1775: WHEN OTHERS THEN
1776: RETURN FND_API.G_MISS_NUM;
1777:
1778: END Get_Resource_Id;
1779:
1780: FUNCTION Get_Resource_Seq_Num

Line 1805: RETURN FND_API.G_MISS_NUM;

1801: RETURN NULL;
1802:
1803: EXCEPTION
1804: WHEN OTHERS THEN
1805: RETURN FND_API.G_MISS_NUM;
1806:
1807: END Get_Resource_Seq_Num;
1808:
1809: FUNCTION Get_Resource_Type

Line 1831: RETURN FND_API.G_MISS_NUM;

1827: RETURN NULL;
1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: RETURN FND_API.G_MISS_NUM;
1832: END Get_Resource_Type;
1833:
1834: FUNCTION Get_Source
1835: RETURN VARCHAR2

Line 1847: RETURN FND_API.G_MISS_NUM;

1843: RETURN NULL;
1844:
1845: EXCEPTION
1846: WHEN OTHERS THEN
1847: RETURN FND_API.G_MISS_NUM;
1848:
1849: END Get_Source;
1850:
1851: FUNCTION Get_Source_Line

Line 1864: RETURN FND_API.G_MISS_NUM;

1860: RETURN NULL;
1861:
1862: EXCEPTION
1863: WHEN OTHERS THEN
1864: RETURN FND_API.G_MISS_NUM;
1865:
1866: END Get_Source_Line;
1867:
1868: FUNCTION Get_Standard_Rate

Line 1888: RETURN FND_API.G_MISS_NUM;

1884: RETURN NULL;
1885:
1886: EXCEPTION
1887: WHEN OTHERS THEN
1888: RETURN FND_API.G_MISS_NUM;
1889:
1890: END Get_Standard_Rate;
1891:
1892: FUNCTION Get_Task

Line 1916: RETURN FND_API.G_MISS_NUM;

1912: RETURN NULL;
1913:
1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: RETURN FND_API.G_MISS_NUM;
1917:
1918: END Get_Task;
1919:
1920: FUNCTION Get_Transaction_Date

Line 1945: RETURN FND_API.G_MISS_DATE;

1941: RETURN NULL;
1942:
1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: RETURN FND_API.G_MISS_DATE;
1946:
1947: END Get_Transaction_Date;
1948:
1949: FUNCTION Get_Transaction

Line 1962: RETURN FND_API.G_MISS_NUM;

1958: RETURN NULL;
1959:
1960: EXCEPTION
1961: WHEN OTHERS THEN
1962: RETURN FND_API.G_MISS_NUM;
1963:
1964: END Get_Transaction;
1965:
1966: FUNCTION Get_Transaction_Quantity

Line 2018: RETURN FND_API.G_MISS_NUM;

2014: RETURN NULL;
2015:
2016: EXCEPTION
2017: WHEN OTHERS THEN
2018: RETURN FND_API.G_MISS_NUM;
2019:
2020: END Get_Transaction_Quantity;
2021:
2022: FUNCTION Get_Transaction_Type

Line 2046: RETURN FND_API.G_MISS_NUM;

2042: RETURN NULL;
2043:
2044: EXCEPTION
2045: WHEN OTHERS THEN
2046: RETURN FND_API.G_MISS_NUM;
2047:
2048: END Get_Transaction_Type;
2049:
2050: FUNCTION Get_Transaction_Uom

Line 2070: RETURN FND_API.G_MISS_CHAR;

2066: RETURN NULL;
2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070: RETURN FND_API.G_MISS_CHAR;
2071:
2072: END Get_Transaction_Uom;
2073:
2074: FUNCTION Get_Usage_Rate_Or_Amount

Line 2094: RETURN FND_API.G_MISS_NUM;

2090: RETURN NULL;
2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: RETURN FND_API.G_MISS_NUM;
2095:
2096: END Get_Usage_Rate_Or_Amount;
2097:
2098: FUNCTION Get_Wip_Entity

Line 2123: RETURN FND_API.G_MISS_NUM;

2119: RETURN NULL;
2120:
2121: EXCEPTION
2122: WHEN OTHERS THEN
2123: RETURN FND_API.G_MISS_NUM;
2124:
2125: END Get_Wip_Entity;
2126:
2127: FUNCTION Get_Wip_Entity_Name

Line 2147: RETURN FND_API.G_MISS_CHAR;

2143: RETURN NULL;
2144:
2145: EXCEPTION
2146: WHEN OTHERS THEN
2147: RETURN FND_API.G_MISS_CHAR;
2148:
2149: END Get_Wip_Entity_Name;
2150:
2151: PROCEDURE Get_Flex_Res

Line 2157: IF g_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN

2153: BEGIN
2154:
2155: -- In the future call Flex APIs for defaults
2156:
2157: IF g_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2158: g_Res_rec.attribute1 := NULL;
2159: END IF;
2160:
2161: IF g_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 2161: IF g_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN

2157: IF g_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2158: g_Res_rec.attribute1 := NULL;
2159: END IF;
2160:
2161: IF g_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2162: g_Res_rec.attribute10 := NULL;
2163: END IF;
2164:
2165: IF g_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 2165: IF g_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN

2161: IF g_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2162: g_Res_rec.attribute10 := NULL;
2163: END IF;
2164:
2165: IF g_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2166: g_Res_rec.attribute11 := NULL;
2167: END IF;
2168:
2169: IF g_Res_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 2169: IF g_Res_rec.attribute12 = FND_API.G_MISS_CHAR THEN

2165: IF g_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2166: g_Res_rec.attribute11 := NULL;
2167: END IF;
2168:
2169: IF g_Res_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2170: g_Res_rec.attribute12 := NULL;
2171: END IF;
2172:
2173: IF g_Res_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 2173: IF g_Res_rec.attribute13 = FND_API.G_MISS_CHAR THEN

2169: IF g_Res_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2170: g_Res_rec.attribute12 := NULL;
2171: END IF;
2172:
2173: IF g_Res_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2174: g_Res_rec.attribute13 := NULL;
2175: END IF;
2176:
2177: IF g_Res_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 2177: IF g_Res_rec.attribute14 = FND_API.G_MISS_CHAR THEN

2173: IF g_Res_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2174: g_Res_rec.attribute13 := NULL;
2175: END IF;
2176:
2177: IF g_Res_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2178: g_Res_rec.attribute14 := NULL;
2179: END IF;
2180:
2181: IF g_Res_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 2181: IF g_Res_rec.attribute15 = FND_API.G_MISS_CHAR THEN

2177: IF g_Res_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2178: g_Res_rec.attribute14 := NULL;
2179: END IF;
2180:
2181: IF g_Res_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2182: g_Res_rec.attribute15 := NULL;
2183: END IF;
2184:
2185: IF g_Res_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 2185: IF g_Res_rec.attribute2 = FND_API.G_MISS_CHAR THEN

2181: IF g_Res_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2182: g_Res_rec.attribute15 := NULL;
2183: END IF;
2184:
2185: IF g_Res_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2186: g_Res_rec.attribute2 := NULL;
2187: END IF;
2188:
2189: IF g_Res_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 2189: IF g_Res_rec.attribute3 = FND_API.G_MISS_CHAR THEN

2185: IF g_Res_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2186: g_Res_rec.attribute2 := NULL;
2187: END IF;
2188:
2189: IF g_Res_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2190: g_Res_rec.attribute3 := NULL;
2191: END IF;
2192:
2193: IF g_Res_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 2193: IF g_Res_rec.attribute4 = FND_API.G_MISS_CHAR THEN

2189: IF g_Res_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2190: g_Res_rec.attribute3 := NULL;
2191: END IF;
2192:
2193: IF g_Res_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2194: g_Res_rec.attribute4 := NULL;
2195: END IF;
2196:
2197: IF g_Res_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 2197: IF g_Res_rec.attribute5 = FND_API.G_MISS_CHAR THEN

2193: IF g_Res_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2194: g_Res_rec.attribute4 := NULL;
2195: END IF;
2196:
2197: IF g_Res_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2198: g_Res_rec.attribute5 := NULL;
2199: END IF;
2200:
2201: IF g_Res_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 2201: IF g_Res_rec.attribute6 = FND_API.G_MISS_CHAR THEN

2197: IF g_Res_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2198: g_Res_rec.attribute5 := NULL;
2199: END IF;
2200:
2201: IF g_Res_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2202: g_Res_rec.attribute6 := NULL;
2203: END IF;
2204:
2205: IF g_Res_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 2205: IF g_Res_rec.attribute7 = FND_API.G_MISS_CHAR THEN

2201: IF g_Res_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2202: g_Res_rec.attribute6 := NULL;
2203: END IF;
2204:
2205: IF g_Res_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2206: g_Res_rec.attribute7 := NULL;
2207: END IF;
2208:
2209: IF g_Res_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 2209: IF g_Res_rec.attribute8 = FND_API.G_MISS_CHAR THEN

2205: IF g_Res_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2206: g_Res_rec.attribute7 := NULL;
2207: END IF;
2208:
2209: IF g_Res_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2210: g_Res_rec.attribute8 := NULL;
2211: END IF;
2212:
2213: IF g_Res_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 2213: IF g_Res_rec.attribute9 = FND_API.G_MISS_CHAR THEN

2209: IF g_Res_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2210: g_Res_rec.attribute8 := NULL;
2211: END IF;
2212:
2213: IF g_Res_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2214: g_Res_rec.attribute9 := NULL;
2215: END IF;
2216:
2217: IF g_Res_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 2217: IF g_Res_rec.attribute_category = FND_API.G_MISS_CHAR THEN

2213: IF g_Res_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2214: g_Res_rec.attribute9 := NULL;
2215: END IF;
2216:
2217: IF g_Res_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2218: g_Res_rec.attribute_category := NULL;
2219: END IF;
2220:
2221: END Get_Flex_Res;

Line 2244: RAISE FND_API.G_EXC_ERROR;

2240: FND_MSG_PUB.Add;
2241:
2242: END IF;
2243:
2244: RAISE FND_API.G_EXC_ERROR;
2245:
2246: END IF;
2247:
2248: -- Initialize global variables