DBA Data[Home] [Help]

APPS.PA_PROCESS_CI_LINES_PKG dependencies on PA_NUM_TBL_TYPE

Line 15: SUBTYPE g_pa_num_tbl IS SYSTEM.pa_num_tbl_type;

11: RAW_COST NUMBER);
12:
13: TYPE info_rec_tbl IS TABLE OF INFO_REC index by binary_integer;
14:
15: SUBTYPE g_pa_num_tbl IS SYSTEM.pa_num_tbl_type;
16: SUBTYPE g_PA_DATE_TBL IS SYSTEM.PA_DATE_TBL_TYPE;
17: SUBTYPE g_PA_VARCHAR2_1_TBL IS SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
18: SUBTYPE g_PA_VARCHAR2_15_TBL IS SYSTEM.PA_VARCHAR2_15_TBL_TYPE;
19: SUBTYPE g_PA_VARCHAR2_30_TBL IS SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 36: p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

32: p_calling_context IN VARCHAR2,
33: p_action_type IN VARCHAR2,
34: p_bvid IN NUMBER,
35: p_ci_id IN NUMBER,
36: p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
37: p_project_id IN NUMBER,
38: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
39: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
40: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 38: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

34: p_bvid IN NUMBER,
35: p_ci_id IN NUMBER,
36: p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
37: p_project_id IN NUMBER,
38: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
39: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
40: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
41: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
42: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 40: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

36: p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
37: p_project_id IN NUMBER,
38: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
39: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
40: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
41: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
42: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
43: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
44: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 41: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

37: p_project_id IN NUMBER,
38: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
39: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
40: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
41: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
42: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
43: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
44: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
45: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 42: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE

38: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
39: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
40: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
41: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
42: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
43: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
44: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
45: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
46: );

Line 43: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

39: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
40: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
41: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
42: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
43: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
44: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
45: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
46: );
47:

Line 44: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

40: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
41: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
42: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
43: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
44: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
45: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
46: );
47:
48: procedure insert_planning_transaction(p_api_version IN NUMBER,

Line 45: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

41: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
42: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
43: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
44: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
45: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
46: );
47:
48: procedure insert_planning_transaction(p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2,

Line 55: P_TASK_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,

51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: P_BVID IN NUMBER,
54: P_PROJECT_ID IN NUMBER,
55: P_TASK_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
56: P_RLMI_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
57: P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
58: P_QUANTITY_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
59: P_RAW_COST_TBL IN SYSTEM.PA_NUM_TBL_TYPE

Line 56: P_RLMI_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,

52: x_msg_data OUT NOCOPY VARCHAR2,
53: P_BVID IN NUMBER,
54: P_PROJECT_ID IN NUMBER,
55: P_TASK_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
56: P_RLMI_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
57: P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
58: P_QUANTITY_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
59: P_RAW_COST_TBL IN SYSTEM.PA_NUM_TBL_TYPE
60: );

Line 58: P_QUANTITY_TBL IN SYSTEM.PA_NUM_TBL_TYPE,

54: P_PROJECT_ID IN NUMBER,
55: P_TASK_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
56: P_RLMI_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
57: P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
58: P_QUANTITY_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
59: P_RAW_COST_TBL IN SYSTEM.PA_NUM_TBL_TYPE
60: );
61:
62: procedure delete_planning_transaction(p_api_version IN NUMBER,

Line 59: P_RAW_COST_TBL IN SYSTEM.PA_NUM_TBL_TYPE

55: P_TASK_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
56: P_RLMI_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
57: P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
58: P_QUANTITY_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
59: P_RAW_COST_TBL IN SYSTEM.PA_NUM_TBL_TYPE
60: );
61:
62: procedure delete_planning_transaction(p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2,

Line 69: p_task_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_bvid IN number,
68: p_project_id IN NUMBER,
69: p_task_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
70: p_currency_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
71: p_rlmi_tbl IN SYSTEM.PA_NUM_TBL_TYPE
72: );
73:

Line 71: p_rlmi_tbl IN SYSTEM.PA_NUM_TBL_TYPE

67: p_bvid IN number,
68: p_project_id IN NUMBER,
69: p_task_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
70: p_currency_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
71: p_rlmi_tbl IN SYSTEM.PA_NUM_TBL_TYPE
72: );
73:
74: procedure update_planning_transaction(p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2,

Line 81: p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,

77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_bvid IN NUMBER,
80: p_project_id in NUMBER,
81: p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,
82: p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
83: p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
84: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
85: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 84: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

80: p_project_id in NUMBER,
81: p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,
82: p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
83: p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
84: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
85: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
86: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
87: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
88: );

Line 85: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

81: p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,
82: p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
83: p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
84: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
85: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
86: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
87: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
88: );
89:

Line 86: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

82: p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
83: p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
84: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
85: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
86: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
87: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
88: );
89:
90: end pa_process_ci_lines_pkg;