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;
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,
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
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
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()
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: );
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:
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,
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,
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
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: );
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,
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,
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:
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,
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,
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: );
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:
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;