eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CORE_S dependencies on PO_TBL_NUMBER

Line 927: l_period_year_tbl po_tbl_number;

923: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_PERIOD_NAME';
924: l_progress VARCHAR2(3) := '000';
925:
926: l_period_name_tbl po_tbl_varchar30;
927: l_period_year_tbl po_tbl_number;
928: l_period_num_tbl po_tbl_number;
929: l_quarter_num_tbl po_tbl_number;
930: l_invalid_period_flag VARCHAR2(1);
931:

Line 928: l_period_num_tbl po_tbl_number;

924: l_progress VARCHAR2(3) := '000';
925:
926: l_period_name_tbl po_tbl_varchar30;
927: l_period_year_tbl po_tbl_number;
928: l_period_num_tbl po_tbl_number;
929: l_quarter_num_tbl po_tbl_number;
930: l_invalid_period_flag VARCHAR2(1);
931:
932: BEGIN

Line 929: l_quarter_num_tbl po_tbl_number;

925:
926: l_period_name_tbl po_tbl_varchar30;
927: l_period_year_tbl po_tbl_number;
928: l_period_num_tbl po_tbl_number;
929: l_quarter_num_tbl po_tbl_number;
930: l_invalid_period_flag VARCHAR2(1);
931:
932: BEGIN
933:

Line 4057: , p_doc_level_id_tbl IN po_tbl_number

4053: -------------------------------------------------------------------------------
4054: PROCEDURE get_document_ids(
4055: p_doc_type IN VARCHAR2
4056: , p_doc_level IN VARCHAR2
4057: , p_doc_level_id_tbl IN po_tbl_number
4058: , x_doc_id_tbl OUT NOCOPY po_tbl_number
4059: )
4060: IS
4061:

Line 4058: , x_doc_id_tbl OUT NOCOPY po_tbl_number

4054: PROCEDURE get_document_ids(
4055: p_doc_type IN VARCHAR2
4056: , p_doc_level IN VARCHAR2
4057: , p_doc_level_id_tbl IN po_tbl_number
4058: , x_doc_id_tbl OUT NOCOPY po_tbl_number
4059: )
4060: IS
4061:
4062: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_DOCUMENT_IDS';

Line 4356: , p_doc_level_id_tbl IN po_tbl_number

4352: -- Overloaded procedure
4353: PROCEDURE get_line_ids(
4354: p_doc_type IN VARCHAR2
4355: , p_doc_level IN VARCHAR2
4356: , p_doc_level_id_tbl IN po_tbl_number
4357: , x_line_id_tbl OUT NOCOPY po_tbl_number
4358: )
4359: IS
4360: BEGIN

Line 4357: , x_line_id_tbl OUT NOCOPY po_tbl_number

4353: PROCEDURE get_line_ids(
4354: p_doc_type IN VARCHAR2
4355: , p_doc_level IN VARCHAR2
4356: , p_doc_level_id_tbl IN po_tbl_number
4357: , x_line_id_tbl OUT NOCOPY po_tbl_number
4358: )
4359: IS
4360: BEGIN
4361: get_line_ids(

Line 4407: , p_doc_level_id_tbl IN po_tbl_number

4403: -------------------------------------------------------------------------------
4404: PROCEDURE get_line_ids(
4405: p_doc_type IN VARCHAR2
4406: , p_doc_level IN VARCHAR2
4407: , p_doc_level_id_tbl IN po_tbl_number
4408: , p_draft_id IN NUMBER --
4409: , x_line_id_tbl OUT NOCOPY po_tbl_number
4410: )
4411: IS

Line 4409: , x_line_id_tbl OUT NOCOPY po_tbl_number

4405: p_doc_type IN VARCHAR2
4406: , p_doc_level IN VARCHAR2
4407: , p_doc_level_id_tbl IN po_tbl_number
4408: , p_draft_id IN NUMBER --
4409: , x_line_id_tbl OUT NOCOPY po_tbl_number
4410: )
4411: IS
4412:
4413: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_LINE_IDS';

Line 4701: , p_doc_level_id_tbl IN po_tbl_number

4697: -- Overloaded procedure
4698: PROCEDURE get_line_location_ids(
4699: p_doc_type IN VARCHAR2
4700: , p_doc_level IN VARCHAR2
4701: , p_doc_level_id_tbl IN po_tbl_number
4702: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
4703: )
4704: IS
4705: BEGIN

Line 4702: , x_line_location_id_tbl OUT NOCOPY po_tbl_number

4698: PROCEDURE get_line_location_ids(
4699: p_doc_type IN VARCHAR2
4700: , p_doc_level IN VARCHAR2
4701: , p_doc_level_id_tbl IN po_tbl_number
4702: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
4703: )
4704: IS
4705: BEGIN
4706: get_line_location_ids(

Line 4754: , p_doc_level_id_tbl IN po_tbl_number

4750: -------------------------------------------------------------------------------
4751: PROCEDURE get_line_location_ids(
4752: p_doc_type IN VARCHAR2
4753: , p_doc_level IN VARCHAR2
4754: , p_doc_level_id_tbl IN po_tbl_number
4755: , p_draft_id IN NUMBER --
4756: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
4757: )
4758: IS

Line 4756: , x_line_location_id_tbl OUT NOCOPY po_tbl_number

4752: p_doc_type IN VARCHAR2
4753: , p_doc_level IN VARCHAR2
4754: , p_doc_level_id_tbl IN po_tbl_number
4755: , p_draft_id IN NUMBER --
4756: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
4757: )
4758: IS
4759:
4760: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_LINE_LOCATION_IDS';

Line 4969: , p_doc_level_id_tbl IN po_tbl_number

4965:
4966: PROCEDURE get_distribution_ids(
4967: p_doc_type IN VARCHAR2
4968: , p_doc_level IN VARCHAR2
4969: , p_doc_level_id_tbl IN po_tbl_number
4970: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
4971: )
4972: IS
4973: BEGIN

Line 4970: , x_distribution_id_tbl OUT NOCOPY po_tbl_number

4966: PROCEDURE get_distribution_ids(
4967: p_doc_type IN VARCHAR2
4968: , p_doc_level IN VARCHAR2
4969: , p_doc_level_id_tbl IN po_tbl_number
4970: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
4971: )
4972: IS
4973: BEGIN
4974: get_distribution_ids(

Line 5020: , p_doc_level_id_tbl IN po_tbl_number

5016: -------------------------------------------------------------------------------
5017: PROCEDURE get_distribution_ids(
5018: p_doc_type IN VARCHAR2
5019: , p_doc_level IN VARCHAR2
5020: , p_doc_level_id_tbl IN po_tbl_number
5021: , p_draft_id IN NUMBER --
5022: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
5023: )
5024: IS

Line 5022: , x_distribution_id_tbl OUT NOCOPY po_tbl_number

5018: p_doc_type IN VARCHAR2
5019: , p_doc_level IN VARCHAR2
5020: , p_doc_level_id_tbl IN po_tbl_number
5021: , p_draft_id IN NUMBER --
5022: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
5023: )
5024: IS
5025:
5026: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_DISTRIBUTION_IDS';

Line 5308: , p_doc_level_id_tbl IN po_tbl_number

5304: -------------------------------------------------------------------------------
5305: PROCEDURE get_dist_ids_from_archive(
5306: p_doc_type IN VARCHAR2
5307: , p_doc_level IN VARCHAR2
5308: , p_doc_level_id_tbl IN po_tbl_number
5309: , p_doc_revision_num IN NUMBER
5310: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
5311: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
5312: )

Line 5310: , x_distribution_id_tbl OUT NOCOPY po_tbl_number

5306: p_doc_type IN VARCHAR2
5307: , p_doc_level IN VARCHAR2
5308: , p_doc_level_id_tbl IN po_tbl_number
5309: , p_doc_revision_num IN NUMBER
5310: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
5311: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
5312: )
5313: IS
5314:

Line 5311: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number

5307: , p_doc_level IN VARCHAR2
5308: , p_doc_level_id_tbl IN po_tbl_number
5309: , p_doc_revision_num IN NUMBER
5310: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
5311: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
5312: )
5313: IS
5314:
5315: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_DIST_IDS_FROM_ARCHIVE';