APPS.PO_ASL_DOCUMENTS_THS dependencies on PO_ASL_DOCUMENTS

Line 1: PACKAGE BODY PO_ASL_DOCUMENTS_THS as

1: PACKAGE BODY PO_ASL_DOCUMENTS_THS as
2: /* $Header: POXA9LSB.pls 120.1 2007/12/12 09:05:26 irasoolm ship $ */
3:
4: /*=============================================================================
5:

Line 43: FROM PO_ASL_DOCUMENTS

39:
40: x_record_unique boolean;
41:
42: cursor row_id is SELECT rowid
43: FROM PO_ASL_DOCUMENTS
44: WHERE x_asl_id = asl_id
45: AND x_using_organization_id = using_organization_id
46: AND x_sequence_num = sequence_num;
47:

Line 54: x_record_unique := po_asl_documents_sv.check_record_unique(x_asl_id,

50: -- Check for duplicate sequence numbers for this asl_id
51: -- and using_organization_id. The uniqueness constraint
52: -- on document_header_id is enforced by a unique index.
53:
54: x_record_unique := po_asl_documents_sv.check_record_unique(x_asl_id,
55: x_using_organization_id,
56: x_sequence_num,
57: x_document_header_id,
58: x_record_status); --bug 6504696

Line 67: INSERT INTO PO_ASL_DOCUMENTS(

63: app_exception.raise_exception;
64:
65: END IF;
66:
67: INSERT INTO PO_ASL_DOCUMENTS(
68: asl_id ,
69: using_organization_id ,
70: sequence_num ,
71: document_type_code ,

Line 135: END PO_ASL_DOCUMENTS_THS;

131: CLOSE row_id;
132:
133: end insert_row;
134:
135: END PO_ASL_DOCUMENTS_THS;