DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_TBL_NUMBER

Line 907: PROCEDURE update_gms_distributions(p_origDistIds IN PO_TBL_NUMBER,

903: return l_buffer;
904:
905: END jumpIntoFunction;
906:
907: PROCEDURE update_gms_distributions(p_origDistIds IN PO_TBL_NUMBER,
908: p_tempDistIds IN PO_TBL_NUMBER) IS
909: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
910: l_forGMSProjectId po_req_distributions_all.project_id%type;
911: l_forGMSTaskId po_req_distributions_all.task_id%type;

Line 908: p_tempDistIds IN PO_TBL_NUMBER) IS

904:
905: END jumpIntoFunction;
906:
907: PROCEDURE update_gms_distributions(p_origDistIds IN PO_TBL_NUMBER,
908: p_tempDistIds IN PO_TBL_NUMBER) IS
909: l_forGMSReqDistributionId po_req_distributions_all.distribution_id%type;
910: l_forGMSProjectId po_req_distributions_all.project_id%type;
911: l_forGMSTaskId po_req_distributions_all.task_id%type;
912: l_forGMSAwardId po_req_distributions_all.req_award_id%type;

Line 1144: p_origLineIds IN PO_TBL_NUMBER,

1140:
1141:
1142: PROCEDURE restore_working_copy_req(p_origHeaderId IN NUMBER,
1143: p_tempHeaderId IN NUMBER,
1144: p_origLineIds IN PO_TBL_NUMBER,
1145: p_tempLineIds IN PO_TBL_NUMBER,
1146: p_origDistIds IN PO_TBL_NUMBER,
1147: p_tempDistIds IN PO_TBL_NUMBER,
1148: p_origReqSupplierIds IN PO_TBL_NUMBER,

Line 1145: p_tempLineIds IN PO_TBL_NUMBER,

1141:
1142: PROCEDURE restore_working_copy_req(p_origHeaderId IN NUMBER,
1143: p_tempHeaderId IN NUMBER,
1144: p_origLineIds IN PO_TBL_NUMBER,
1145: p_tempLineIds IN PO_TBL_NUMBER,
1146: p_origDistIds IN PO_TBL_NUMBER,
1147: p_tempDistIds IN PO_TBL_NUMBER,
1148: p_origReqSupplierIds IN PO_TBL_NUMBER,
1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,

Line 1146: p_origDistIds IN PO_TBL_NUMBER,

1142: PROCEDURE restore_working_copy_req(p_origHeaderId IN NUMBER,
1143: p_tempHeaderId IN NUMBER,
1144: p_origLineIds IN PO_TBL_NUMBER,
1145: p_tempLineIds IN PO_TBL_NUMBER,
1146: p_origDistIds IN PO_TBL_NUMBER,
1147: p_tempDistIds IN PO_TBL_NUMBER,
1148: p_origReqSupplierIds IN PO_TBL_NUMBER,
1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,
1150: p_origPriceDiffIds IN PO_TBL_NUMBER,

Line 1147: p_tempDistIds IN PO_TBL_NUMBER,

1143: p_tempHeaderId IN NUMBER,
1144: p_origLineIds IN PO_TBL_NUMBER,
1145: p_tempLineIds IN PO_TBL_NUMBER,
1146: p_origDistIds IN PO_TBL_NUMBER,
1147: p_tempDistIds IN PO_TBL_NUMBER,
1148: p_origReqSupplierIds IN PO_TBL_NUMBER,
1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,
1150: p_origPriceDiffIds IN PO_TBL_NUMBER,
1151: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS

Line 1148: p_origReqSupplierIds IN PO_TBL_NUMBER,

1144: p_origLineIds IN PO_TBL_NUMBER,
1145: p_tempLineIds IN PO_TBL_NUMBER,
1146: p_origDistIds IN PO_TBL_NUMBER,
1147: p_tempDistIds IN PO_TBL_NUMBER,
1148: p_origReqSupplierIds IN PO_TBL_NUMBER,
1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,
1150: p_origPriceDiffIds IN PO_TBL_NUMBER,
1151: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS
1152:

Line 1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,

1145: p_tempLineIds IN PO_TBL_NUMBER,
1146: p_origDistIds IN PO_TBL_NUMBER,
1147: p_tempDistIds IN PO_TBL_NUMBER,
1148: p_origReqSupplierIds IN PO_TBL_NUMBER,
1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,
1150: p_origPriceDiffIds IN PO_TBL_NUMBER,
1151: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS
1152:
1153: l_origReqNumber po_requisition_headers_all.segment1%TYPE;

Line 1150: p_origPriceDiffIds IN PO_TBL_NUMBER,

1146: p_origDistIds IN PO_TBL_NUMBER,
1147: p_tempDistIds IN PO_TBL_NUMBER,
1148: p_origReqSupplierIds IN PO_TBL_NUMBER,
1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,
1150: p_origPriceDiffIds IN PO_TBL_NUMBER,
1151: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS
1152:
1153: l_origReqNumber po_requisition_headers_all.segment1%TYPE;
1154: l_progress VARCHAR2(4) := '000';

Line 1151: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS

1147: p_tempDistIds IN PO_TBL_NUMBER,
1148: p_origReqSupplierIds IN PO_TBL_NUMBER,
1149: p_tempReqSupplierIds IN PO_TBL_NUMBER,
1150: p_origPriceDiffIds IN PO_TBL_NUMBER,
1151: p_tempPriceDiffIds IN PO_TBL_NUMBER) IS
1152:
1153: l_origReqNumber po_requisition_headers_all.segment1%TYPE;
1154: l_progress VARCHAR2(4) := '000';
1155: l_status po_requisition_headers_all.authorization_status%TYPE;

Line 2594: p_doc_level_id_tbl IN po_tbl_number,

2590: p_doc_type IN VARCHAR2,
2591: p_doc_subtype IN VARCHAR2,
2592: p_dist_data IN ICX_ENC_IN_TYPE,
2593: p_doc_level IN VARCHAR2,
2594: p_doc_level_id_tbl IN po_tbl_number,
2595: p_override_funds IN VARCHAR2,
2596: p_use_gl_date IN VARCHAR2,
2597: p_override_date IN DATE,
2598: p_report_successes IN VARCHAR2,

Line 2671: p_doc_level_id_tbl IN po_tbl_number,

2667: x_return_status OUT NOCOPY VARCHAR2,
2668: p_doc_type IN VARCHAR2,
2669: p_doc_subtype IN VARCHAR2,
2670: p_doc_level IN VARCHAR2,
2671: p_doc_level_id_tbl IN po_tbl_number,
2672: p_prevent_partial_flag IN VARCHAR2,
2673: p_employee_id IN NUMBER,
2674: p_override_funds IN VARCHAR2,
2675: p_report_successes IN VARCHAR2,

Line 2770: p_doc_level_id_tbl IN po_tbl_number,

2766: x_return_status OUT NOCOPY VARCHAR2,
2767: p_doc_type IN VARCHAR2,
2768: p_doc_subtype IN VARCHAR2,
2769: p_doc_level IN VARCHAR2,
2770: p_doc_level_id_tbl IN po_tbl_number,
2771: p_override_funds IN VARCHAR2,
2772: p_employee_id IN NUMBER,
2773: p_use_gl_date IN VARCHAR2,
2774: p_override_date IN DATE,

Line 2948: l_requisition_line_id po_tbl_number;

2944: p_item_id IN NUMBER,
2945: p_category_id IN NUMBER) IS
2946:
2947:
2948: l_requisition_line_id po_tbl_number;
2949: l_attribute_code po_tbl_varchar30;
2950: l_attribute_label_long po_tbl_varchar60;
2951: l_attribute_value po_tbl_varchar2000;
2952: l_created_by po_tbl_number;

Line 2952: l_created_by po_tbl_number;

2948: l_requisition_line_id po_tbl_number;
2949: l_attribute_code po_tbl_varchar30;
2950: l_attribute_label_long po_tbl_varchar60;
2951: l_attribute_value po_tbl_varchar2000;
2952: l_created_by po_tbl_number;
2953: l_creation_date po_tbl_date;
2954: l_last_updated_by po_tbl_number;
2955: l_last_update_date po_tbl_date;
2956: l_last_update_login po_tbl_number;

Line 2954: l_last_updated_by po_tbl_number;

2950: l_attribute_label_long po_tbl_varchar60;
2951: l_attribute_value po_tbl_varchar2000;
2952: l_created_by po_tbl_number;
2953: l_creation_date po_tbl_date;
2954: l_last_updated_by po_tbl_number;
2955: l_last_update_date po_tbl_date;
2956: l_last_update_login po_tbl_number;
2957: l_attribute1 po_tbl_varchar2000;
2958: l_attribute2 po_tbl_varchar2000;

Line 2956: l_last_update_login po_tbl_number;

2952: l_created_by po_tbl_number;
2953: l_creation_date po_tbl_date;
2954: l_last_updated_by po_tbl_number;
2955: l_last_update_date po_tbl_date;
2956: l_last_update_login po_tbl_number;
2957: l_attribute1 po_tbl_varchar2000;
2958: l_attribute2 po_tbl_varchar2000;
2959: l_attribute3 po_tbl_varchar2000;
2960: l_attribute4 po_tbl_varchar2000;