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 654: RETURN FND_API.G_MISS_NUM;

650: RETURN NULL;
651:
652: EXCEPTION
653: WHEN OTHERS THEN
654: RETURN FND_API.G_MISS_NUM;
655:
656: END Get_Actual_Resource_Rate;
657:
658: FUNCTION Get_Autocharge_Type

Line 680: RETURN FND_API.G_MISS_NUM;

676: END IF;
677:
678: EXCEPTION
679: WHEN OTHERS THEN
680: RETURN FND_API.G_MISS_NUM;
681:
682: END Get_Autocharge_Type;
683:
684: FUNCTION Get_Basis_Type

Line 702: RETURN FND_API.G_MISS_NUM;

698: END IF;
699:
700: EXCEPTION
701: WHEN OTHERS THEN
702: RETURN FND_API.G_MISS_NUM;
703:
704: END Get_Basis_Type;
705:
706: FUNCTION Get_Completion_Transaction

Line 719: RETURN FND_API.G_MISS_NUM;

715: RETURN NULL;
716:
717: EXCEPTION
718: WHEN OTHERS THEN
719: RETURN FND_API.G_MISS_NUM;
720:
721: END Get_Completion_Transaction;
722:
723: FUNCTION Get_Created_By

Line 748: RETURN FND_API.G_MISS_CHAR;

744: RETURN fnd_global.user_id ;
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: RETURN FND_API.G_MISS_CHAR;
749:
750: END Get_Created_By;
751:
752:

Line 775: RETURN FND_API.G_MISS_CHAR;

771: RETURN NULL;
772:
773: EXCEPTION
774: WHEN OTHERS THEN
775: RETURN FND_API.G_MISS_CHAR;
776:
777: END Get_Created_By_Name;
778:
779: FUNCTION Get_Creation_Date

Line 804: RETURN FND_API.G_MISS_DATE;

800: RETURN sysdate ;
801:
802: EXCEPTION
803: WHEN OTHERS THEN
804: RETURN FND_API.G_MISS_DATE;
805:
806: END Get_Creation_Date;
807:
808:

Line 836: RETURN FND_API.G_MISS_NUM;

832: RETURN NULL;
833:
834: EXCEPTION
835: WHEN OTHERS THEN
836: RETURN FND_API.G_MISS_NUM;
837:
838: END Get_Currency_Actual_Rsc_Rate;
839:
840: FUNCTION Get_Currency

Line 866: RETURN FND_API.G_MISS_NUM;

862: RETURN NULL;
863:
864: EXCEPTION
865: WHEN OTHERS THEN
866: RETURN FND_API.G_MISS_NUM;
867:
868: END Get_Currency;
869:
870: FUNCTION Get_Currency_Conversion_Date

Line 895: RETURN FND_API.G_MISS_DATE;

891: RETURN NULL;
892:
893: EXCEPTION
894: WHEN OTHERS THEN
895: RETURN FND_API.G_MISS_DATE;
896: END Get_Currency_Conversion_Date;
897:
898: FUNCTION Get_Currency_Conversion_Rate
899: RETURN NUMBER

Line 923: RETURN FND_API.G_MISS_NUM;

919: RETURN NULL;
920:
921: EXCEPTION
922: WHEN OTHERS THEN
923: RETURN FND_API.G_MISS_NUM;
924:
925: END Get_Currency_Conversion_Rate;
926:
927: FUNCTION Get_Currency_Conversion_Type

Line 952: RETURN FND_API.G_MISS_NUM;

948: RETURN NULL;
949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: RETURN FND_API.G_MISS_NUM;
953:
954: END Get_Currency_Conversion_Type;
955:
956: FUNCTION Get_Department_Code

Line 980: RETURN FND_API.G_MISS_CHAR;

976: RETURN NULL;
977:
978: EXCEPTION
979: WHEN OTHERS THEN
980: RETURN FND_API.G_MISS_CHAR;
981:
982: END Get_Department_Code;
983:
984: FUNCTION Get_Department_Id

Line 1013: RETURN FND_API.G_MISS_NUM;

1009: RETURN NULL;
1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: RETURN FND_API.G_MISS_NUM;
1014:
1015: END Get_Department_Id;
1016:
1017: FUNCTION Get_Employee

Line 1030: RETURN FND_API.G_MISS_NUM;

1026: RETURN NULL;
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: RETURN FND_API.G_MISS_NUM;
1031:
1032: END Get_Employee;
1033:
1034: FUNCTION Get_Employee_Num

Line 1047: RETURN FND_API.G_MISS_CHAR;

1043: RETURN NULL;
1044:
1045: EXCEPTION
1046: WHEN OTHERS THEN
1047: RETURN FND_API.G_MISS_CHAR;
1048:
1049: END Get_Employee_Num;
1050:
1051: FUNCTION Get_Entity_Type

Line 1071: RETURN FND_API.G_MISS_NUM;

1067: RETURN NULL;
1068:
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: RETURN FND_API.G_MISS_NUM;
1072:
1073: END Get_Entity_Type;
1074:
1075: FUNCTION Get_Group

Line 1088: RETURN FND_API.G_MISS_NUM;

1084: RETURN NULL;
1085:
1086: EXCEPTION
1087: WHEN OTHERS THEN
1088: RETURN FND_API.G_MISS_NUM;
1089:
1090: END Get_Group;
1091:
1092: FUNCTION Get_Last_Updated_By

Line 1117: RETURN FND_API.G_MISS_CHAR;

1113: RETURN fnd_global.user_id ;
1114:
1115: EXCEPTION
1116: WHEN OTHERS THEN
1117: RETURN FND_API.G_MISS_CHAR;
1118:
1119: END Get_Last_Updated_By;
1120:
1121: FUNCTION Get_Last_Updated_By_Name

Line 1143: RETURN FND_API.G_MISS_CHAR;

1139: RETURN NULL;
1140:
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: RETURN FND_API.G_MISS_CHAR;
1144:
1145: END Get_Last_Updated_By_Name;
1146:
1147: FUNCTION Get_Last_Update_Date

Line 1172: RETURN FND_API.G_MISS_CHAR;

1168: RETURN sysdate ;
1169:
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: RETURN FND_API.G_MISS_CHAR;
1173:
1174: END Get_Last_Update_Date;
1175:
1176:

Line 1202: RETURN FND_API.G_MISS_CHAR;

1198: RETURN NULL;
1199:
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: RETURN FND_API.G_MISS_CHAR;
1203:
1204: END Get_Line_Code;
1205:
1206: FUNCTION Get_Line_Id

Line 1231: RETURN FND_API.G_MISS_NUM;

1227: RETURN NULL;
1228:
1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: RETURN FND_API.G_MISS_NUM;
1232:
1233: END Get_Line_Id;
1234:
1235: FUNCTION Get_Move_Transaction

Line 1248: RETURN FND_API.G_MISS_NUM;

1244: RETURN NULL;
1245:
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: RETURN FND_API.G_MISS_NUM;
1249:
1250: END Get_Move_Transaction;
1251:
1252: FUNCTION Get_Operation_Seq_Num

Line 1277: RETURN FND_API.G_MISS_NUM;

1273: RETURN NULL;
1274:
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: RETURN FND_API.G_MISS_NUM;
1278:
1279: END Get_Operation_Seq_Num;
1280:
1281: FUNCTION Get_Organization_Code

Line 1303: RETURN FND_API.G_MISS_CHAR;

1299: RETURN NULL;
1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: RETURN FND_API.G_MISS_CHAR;
1304:
1305: END Get_Organization_Code;
1306:
1307: FUNCTION Get_Organization_Id

Line 1332: RETURN FND_API.G_MISS_NUM;

1328: RETURN NULL;
1329:
1330: EXCEPTION
1331: WHEN OTHERS THEN
1332: RETURN FND_API.G_MISS_NUM;
1333:
1334: END Get_Organization_Id;
1335:
1336: FUNCTION Get_Po_Header

Line 1361: RETURN FND_API.G_MISS_NUM;

1357: RETURN NULL;
1358:
1359: EXCEPTION
1360: WHEN OTHERS THEN
1361: RETURN FND_API.G_MISS_NUM;
1362:
1363: END Get_Po_Header;
1364:
1365: FUNCTION Get_Po_Line

Line 1390: RETURN FND_API.G_MISS_NUM;

1386: RETURN NULL;
1387:
1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: RETURN FND_API.G_MISS_NUM;
1391:
1392: END Get_Po_Line;
1393:
1394: FUNCTION Get_Primary_Item

Line 1414: RETURN FND_API.G_MISS_NUM;

1410: RETURN NULL;
1411:
1412: EXCEPTION
1413: WHEN OTHERS THEN
1414: RETURN FND_API.G_MISS_NUM;
1415:
1416: END Get_Primary_Item;
1417:
1418: FUNCTION Get_Primary_Quantity

Line 1435: RETURN FND_API.G_MISS_NUM;

1431: RETURN NULL;
1432:
1433: EXCEPTION
1434: WHEN OTHERS THEN
1435: RETURN FND_API.G_MISS_NUM;
1436:
1437: END Get_Primary_Quantity;
1438:
1439: FUNCTION Get_Primary_Uom

Line 1459: RETURN FND_API.G_MISS_CHAR;

1455: RETURN NULL;
1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: RETURN FND_API.G_MISS_CHAR;
1460:
1461: END Get_Primary_Uom;
1462:
1463: FUNCTION Get_Primary_Uom_Class

Line 1476: RETURN FND_API.G_MISS_CHAR;

1472: RETURN NULL;
1473:
1474: EXCEPTION
1475: WHEN OTHERS THEN
1476: RETURN FND_API.G_MISS_CHAR;
1477:
1478: END Get_Primary_Uom_Class;
1479:
1480: FUNCTION Get_Process_Phase

Line 1505: RETURN FND_API.G_MISS_NUM;

1501: RETURN NULL;
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: RETURN FND_API.G_MISS_NUM;
1506:
1507: END Get_Process_Phase;
1508:
1509: FUNCTION Get_Process_Status

Line 1533: RETURN FND_API.G_MISS_NUM;

1529: RETURN NULL;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: RETURN FND_API.G_MISS_NUM;
1534:
1535: END Get_Process_Status;
1536:
1537: FUNCTION Get_Project

Line 1562: RETURN FND_API.G_MISS_NUM;

1558: RETURN NULL;
1559:
1560: EXCEPTION
1561: WHEN OTHERS THEN
1562: RETURN FND_API.G_MISS_NUM;
1563:
1564: END Get_Project;
1565:
1566: FUNCTION Get_Rcv_Transaction

Line 1579: RETURN FND_API.G_MISS_NUM;

1575: RETURN NULL;
1576:
1577: EXCEPTION
1578: WHEN OTHERS THEN
1579: RETURN FND_API.G_MISS_NUM;
1580:
1581: END Get_Rcv_Transaction;
1582:
1583: FUNCTION Get_Reason

Line 1608: RETURN FND_API.G_MISS_NUM;

1604: RETURN NULL;
1605:
1606: EXCEPTION
1607: WHEN OTHERS THEN
1608: RETURN FND_API.G_MISS_NUM;
1609:
1610: END Get_Reason;
1611:
1612: FUNCTION Get_Reason_Name

Line 1636: RETURN FND_API.G_MISS_CHAR;

1632: RETURN NULL;
1633:
1634: EXCEPTION
1635: WHEN OTHERS THEN
1636: RETURN FND_API.G_MISS_CHAR;
1637:
1638: END Get_Reason_Name;
1639:
1640: FUNCTION Get_Receiving_Account

Line 1664: RETURN FND_API.G_MISS_NUM;

1660: RETURN NULL;
1661:
1662: EXCEPTION
1663: WHEN OTHERS THEN
1664: RETURN FND_API.G_MISS_NUM;
1665:
1666: END Get_Receiving_Account;
1667:
1668: FUNCTION Get_Reference

Line 1693: RETURN FND_API.G_MISS_CHAR;

1689: RETURN NULL;
1690:
1691: EXCEPTION
1692: WHEN OTHERS THEN
1693: RETURN FND_API.G_MISS_CHAR;
1694:
1695: END Get_Reference;
1696:
1697: FUNCTION Get_Repetitive_Schedule

Line 1722: RETURN FND_API.G_MISS_NUM;

1718: RETURN NULL;
1719:
1720: EXCEPTION
1721: WHEN OTHERS THEN
1722: RETURN FND_API.G_MISS_NUM;
1723:
1724: END Get_Repetitive_Schedule;
1725:
1726: FUNCTION Get_Resource_Code

Line 1748: RETURN FND_API.G_MISS_CHAR;

1744: RETURN NULL;
1745:
1746: EXCEPTION
1747: WHEN OTHERS THEN
1748: RETURN FND_API.G_MISS_CHAR;
1749:
1750: END Get_Resource_Code;
1751:
1752: FUNCTION Get_Resource_Id

Line 1772: RETURN FND_API.G_MISS_NUM;

1768: RETURN NULL;
1769:
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: RETURN FND_API.G_MISS_NUM;
1773:
1774: END Get_Resource_Id;
1775:
1776: FUNCTION Get_Resource_Seq_Num

Line 1801: RETURN FND_API.G_MISS_NUM;

1797: RETURN NULL;
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: RETURN FND_API.G_MISS_NUM;
1802:
1803: END Get_Resource_Seq_Num;
1804:
1805: FUNCTION Get_Resource_Type

Line 1827: RETURN FND_API.G_MISS_NUM;

1823: RETURN NULL;
1824:
1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: RETURN FND_API.G_MISS_NUM;
1828: END Get_Resource_Type;
1829:
1830: FUNCTION Get_Source
1831: RETURN VARCHAR2

Line 1843: RETURN FND_API.G_MISS_NUM;

1839: RETURN NULL;
1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: RETURN FND_API.G_MISS_NUM;
1844:
1845: END Get_Source;
1846:
1847: FUNCTION Get_Source_Line

Line 1860: RETURN FND_API.G_MISS_NUM;

1856: RETURN NULL;
1857:
1858: EXCEPTION
1859: WHEN OTHERS THEN
1860: RETURN FND_API.G_MISS_NUM;
1861:
1862: END Get_Source_Line;
1863:
1864: FUNCTION Get_Standard_Rate

Line 1884: RETURN FND_API.G_MISS_NUM;

1880: RETURN NULL;
1881:
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: RETURN FND_API.G_MISS_NUM;
1885:
1886: END Get_Standard_Rate;
1887:
1888: FUNCTION Get_Task

Line 1912: RETURN FND_API.G_MISS_NUM;

1908: RETURN NULL;
1909:
1910: EXCEPTION
1911: WHEN OTHERS THEN
1912: RETURN FND_API.G_MISS_NUM;
1913:
1914: END Get_Task;
1915:
1916: FUNCTION Get_Transaction_Date

Line 1941: RETURN FND_API.G_MISS_DATE;

1937: RETURN NULL;
1938:
1939: EXCEPTION
1940: WHEN OTHERS THEN
1941: RETURN FND_API.G_MISS_DATE;
1942:
1943: END Get_Transaction_Date;
1944:
1945: FUNCTION Get_Transaction

Line 1958: RETURN FND_API.G_MISS_NUM;

1954: RETURN NULL;
1955:
1956: EXCEPTION
1957: WHEN OTHERS THEN
1958: RETURN FND_API.G_MISS_NUM;
1959:
1960: END Get_Transaction;
1961:
1962: FUNCTION Get_Transaction_Quantity

Line 2014: RETURN FND_API.G_MISS_NUM;

2010: RETURN NULL;
2011:
2012: EXCEPTION
2013: WHEN OTHERS THEN
2014: RETURN FND_API.G_MISS_NUM;
2015:
2016: END Get_Transaction_Quantity;
2017:
2018: FUNCTION Get_Transaction_Type

Line 2042: RETURN FND_API.G_MISS_NUM;

2038: RETURN NULL;
2039:
2040: EXCEPTION
2041: WHEN OTHERS THEN
2042: RETURN FND_API.G_MISS_NUM;
2043:
2044: END Get_Transaction_Type;
2045:
2046: FUNCTION Get_Transaction_Uom

Line 2066: RETURN FND_API.G_MISS_CHAR;

2062: RETURN NULL;
2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: RETURN FND_API.G_MISS_CHAR;
2067:
2068: END Get_Transaction_Uom;
2069:
2070: FUNCTION Get_Usage_Rate_Or_Amount

Line 2090: RETURN FND_API.G_MISS_NUM;

2086: RETURN NULL;
2087:
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: RETURN FND_API.G_MISS_NUM;
2091:
2092: END Get_Usage_Rate_Or_Amount;
2093:
2094: FUNCTION Get_Wip_Entity

Line 2119: RETURN FND_API.G_MISS_NUM;

2115: RETURN NULL;
2116:
2117: EXCEPTION
2118: WHEN OTHERS THEN
2119: RETURN FND_API.G_MISS_NUM;
2120:
2121: END Get_Wip_Entity;
2122:
2123: FUNCTION Get_Wip_Entity_Name

Line 2143: RETURN FND_API.G_MISS_CHAR;

2139: RETURN NULL;
2140:
2141: EXCEPTION
2142: WHEN OTHERS THEN
2143: RETURN FND_API.G_MISS_CHAR;
2144:
2145: END Get_Wip_Entity_Name;
2146:
2147: PROCEDURE Get_Flex_Res

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

2149: BEGIN
2150:
2151: -- In the future call Flex APIs for defaults
2152:
2153: IF g_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2154: g_Res_rec.attribute1 := NULL;
2155: END IF;
2156:
2157: IF g_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

2153: IF g_Res_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2154: g_Res_rec.attribute1 := NULL;
2155: END IF;
2156:
2157: IF g_Res_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2158: g_Res_rec.attribute10 := NULL;
2159: END IF;
2160:
2161: IF g_Res_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2240: RAISE FND_API.G_EXC_ERROR;

2236: FND_MSG_PUB.Add;
2237:
2238: END IF;
2239:
2240: RAISE FND_API.G_EXC_ERROR;
2241:
2242: END IF;
2243:
2244: -- Initialize global variables