DBA Data[Home] [Help]

APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_TXN_ATTRIBUTES_S

Line 39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
41: l_res_type_code pa_resource_types.resource_type_code%TYPE;
42:
43: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS

Line 1830: SELECT pa_resource_txn_attributes_s.NEXTVAL

1826:
1827: /* Bug # 932398 Fix : Added flags for non-labor resources in the above cursor */
1828:
1829: CURSOR c_res_txn_attr_seq_csr IS
1830: SELECT pa_resource_txn_attributes_s.NEXTVAL
1831: FROM SYS.DUAL;
1832:
1833: BEGIN
1834: l_old_stack := p_err_stack;

Line 1909: p_err_stage := 'Select pa_resource_txn_attributes_s.nextval from sys.dual ';

1905: ELSE
1906: CLOSE c_res_format_csr;
1907: END IF;
1908:
1909: p_err_stage := 'Select pa_resource_txn_attributes_s.nextval from sys.dual ';
1910:
1911: OPEN c_res_txn_attr_seq_csr;
1912: FETCH c_res_txn_attr_seq_csr INTO
1913: l_resource_txn_attribute_id;

Line 2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2864: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2865: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2866:
2867: