DBA Data[Home] [Help]

APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on PO_AUTOCREATE_TYPES

Line 44: ARGS: OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type (Record variable to hold the header info)

40: /* ============================================================================
41:
42: NAME: fetch_headers
43: DESC: Fetch header details into header record type
44: ARGS: OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type (Record variable to hold the header info)
45: Algorithm: Based on the in parameters select the interface record(s) into
46: the header record type.
47: ==============================================================================*/
48: PROCEDURE fetch_headers( p_interface_header_id IN NUMBER,

Line 49: x_headers OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)

45: Algorithm: Based on the in parameters select the interface record(s) into
46: the header record type.
47: ==============================================================================*/
48: PROCEDURE fetch_headers( p_interface_header_id IN NUMBER,
49: x_headers OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)
50: IS
51: l_api_name VARCHAR2(30) := 'fetch_headers';
52: l_progress VARCHAR2(3) := '000';
53:

Line 674: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type

670: * Derive Pay On Code
671: * Derive Rate (get_rate_for_req_price)
672: * Derive ship to and bill to
673: * Default amount tolerance values for GBPA
674: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type
675: Record variable to hold the header info
676: NOTE: If possible use the procedures from PDOI
677: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
678: - PO_PDOI_HEADER_PROCESS_PVT.derive_rate_type_code

Line 692: PROCEDURE derive_and_default_headers(x_headers IN OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)

688: the index table. For Header set the length of index table
689: (l_index_tbl) to 1.
690: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
691: ============================================================================= */
692: PROCEDURE derive_and_default_headers(x_headers IN OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)
693: IS
694:
695: l_api_name VARCHAR2(30) := 'derive_and_default_headers';
696: l_progress VARCHAR2(3) := '000';

Line 1012: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type -Record variable to hold the header info

1008: First validate the vendor site attribute. If it is valid use it.
1009: Otherwise, validate the vendor attribute. If it is valid then use
1010: that. if that is also not valid, then leave the value to be null.
1011: 2. validate ship to location and bill to location
1012: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type -Record variable to hold the header info
1013: NOTE: Use the following check to validate ship_to and bill_to locations:
1014: select 'Y' into x_is_valid
1015: from hr_locations_all
1016: where location_id = x_valid_ship_to/ x_valid_bill_to

Line 1020: PROCEDURE validate_header( x_headers IN OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)

1016: where location_id = x_valid_ship_to/ x_valid_bill_to
1017: and NVL(ship_to_site_flag, 'N') = 'Y'
1018: and NVL(trunc(inactive_date),trunc(SYSDATE)+1) > trunc(SYSDATE);
1019: ==============================================================================*/
1020: PROCEDURE validate_header( x_headers IN OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)
1021: IS
1022:
1023: l_progress VARCHAR2(3) := '000';
1024: l_api_name CONSTANT VARCHAR2(30) := 'validate_header';

Line 1189: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type

1185:
1186: /* ============================================================================
1187: NAME: merge_to_headers_draft
1188: DESC: Insert/update header records into po_headers_draft_all table.
1189: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type
1190: NOTE: if NEW DOCUMENT
1191: 1. Create a draft record
1192: 2. Create headers_draft record
1193: else if ADD TO DOCUMENT

Line 1204: PROCEDURE merge_to_headers_draft(x_headers IN OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)

1200: 2. update (if required) the headers draft record using headers_rec_type
1201: end;
1202: end;
1203: ===========================================================================*/
1204: PROCEDURE merge_to_headers_draft(x_headers IN OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)
1205: IS
1206:
1207: l_progress VARCHAR2(3) := '000';
1208: l_api_name CONSTANT VARCHAR2(30) := 'merge_to_headers_draft';

Line 1919: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type

1915: /* ============================================================================
1916: NAME: merge_to_org_assign_draft
1917: DESC: Insert rows into po_ga_org_assign draft table;
1918: This applies only to global blanket
1919: ARGS: IN OUT : x_headers PO_AUTOCREATE_TYPES.headers_rec_type
1920: NOTE: if NEW DOCUMENT
1921: 1. Create a ga_org_assignments_draft record.
1922: end;
1923: There would not be an ADD TO scenario for GBPA. So the rest of the

Line 1926: PROCEDURE merge_to_org_assign_draft(x_headers IN OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)

1922: end;
1923: There would not be an ADD TO scenario for GBPA. So the rest of the
1924: if-else is not required.
1925: ==============================================================================*/
1926: PROCEDURE merge_to_org_assign_draft(x_headers IN OUT NOCOPY PO_AUTOCREATE_TYPES.headers_rec_type)
1927: IS
1928:
1929: l_progress VARCHAR2(3) := '000';
1930: l_api_name CONSTANT VARCHAR2(30) := 'merge_to_org_assign_draft';