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_PDOI_HEADER_PROCESS_PVT dependencies on STANDARD

Line 107: PROCEDURE default_clm_standard_format

103: x_headers IN OUT NOCOPY PO_PDOI_TYPES.headers_rec_type
104: );
105:
106: --PDOI CLM Integration Starts
107: PROCEDURE default_clm_standard_format
108: (
109: p_key IN po_session_gt.key%TYPE,
110: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
111: p_style_id_tbl IN PO_TBL_NUMBER,

Line 113: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,

109: p_key IN po_session_gt.key%TYPE,
110: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
111: p_style_id_tbl IN PO_TBL_NUMBER,
112: p_clm_award_type IN PO_TBL_VARCHAR30,
113: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
114: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
115: );
116:
117: PROCEDURE derive_clm_award_type

Line 296: -- standard who columns

292: style_id,
293: style_display_name,
294: global_agreement_flag,
295:
296: -- standard who columns
297: last_update_date,
298: last_updated_by,
299: last_update_login,
300: creation_date,

Line 321: clm_standard_form,

317:
318: -- blanket dist columns
319: NULL, -- po_dist_id -- bug5252250
320: --PDOI CLM Integration
321: clm_standard_form,
322: clm_document_format,
323: clm_award_type,
324: clm_source_document_id,
325: clm_external_idv,

Line 507: -- standard who columns

503: style_id,
504: style_display_name,
505: global_agreement_flag,
506:
507: -- standard who columns
508: last_update_date,
509: last_updated_by,
510: last_update_login,
511: creation_date,

Line 532: clm_standard_form,

528:
529: -- blanket dist columns
530: NULL, -- po_dist_id -- bug5252250
531: --PDOI CLM Integration
532: clm_standard_form,
533: clm_document_format,
534: clm_award_type,
535: clm_source_document_id,
536: clm_external_idv,

Line 718: -- standard who columns

714: x_headers.style_id_tbl,
715: x_headers.style_display_name_tbl,
716: x_headers.global_agreement_flag_tbl,
717:
718: -- standard who columns
719: x_headers.last_update_date_tbl,
720: x_headers.last_updated_by_tbl,
721: x_headers.last_update_login_tbl,
722: x_headers.creation_date_tbl,

Line 744: x_headers.clm_standard_form_tbl,

740:
741: -- blanket dist columns
742: x_headers.po_dist_id_tbl, -- bug5252250
743: --PDOI CLM Integration
744: x_headers.clm_standard_form_tbl,
745: x_headers.clm_document_format_tbl,
746: x_headers.clm_award_type_tbl,
747: x_headers.clm_source_document_id_tbl,
748: x_headers.clm_external_idv_tbl,

Line 1611: x_headers.style_id_tbl(i) := PO_DOC_STYLE_GRP.get_standard_doc_style;

1607: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1608: THEN
1609: NULL;
1610: ELSE
1611: x_headers.style_id_tbl(i) := PO_DOC_STYLE_GRP.get_standard_doc_style;
1612: END IF;
1613: ELSE
1614: x_headers.style_id_tbl(i) :=
1615: NVL(x_headers.style_id_tbl(i), PO_DOC_STYLE_GRP.get_standard_doc_style);

Line 1615: NVL(x_headers.style_id_tbl(i), PO_DOC_STYLE_GRP.get_standard_doc_style);

1611: x_headers.style_id_tbl(i) := PO_DOC_STYLE_GRP.get_standard_doc_style;
1612: END IF;
1613: ELSE
1614: x_headers.style_id_tbl(i) :=
1615: NVL(x_headers.style_id_tbl(i), PO_DOC_STYLE_GRP.get_standard_doc_style);
1616: END IF;
1617:
1618: -- set pay_on_code
1619: x_headers.pay_on_code_tbl(i) := l_site_pay_on_code_tbl(i);

Line 1811: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1807: PO_LOG.stmt(d_module, d_position, 'temp doc num',
1808: x_headers.document_num_tbl(i));
1809: END IF;
1810: END IF;
1811: ELSIF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1812:
1813: d_position := 130;
1814:
1815: -- default revision_num

Line 1965: -- call utility method to default standard who columns

1961: END IF;
1962:
1963: d_position := 190;
1964:
1965: -- call utility method to default standard who columns
1966: PO_PDOI_MAINPROC_UTL_PVT.default_who_columns
1967: (
1968: x_last_update_date_tbl => x_headers.last_update_date_tbl,
1969: x_last_updated_by_tbl => x_headers.last_updated_by_tbl,

Line 1982: default_clm_standard_format

1978:
1979: --CLM PDOI Integration Starts
1980: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1981: THEN
1982: default_clm_standard_format
1983: (
1984: p_key => l_key,
1985: p_index_tbl => l_index_tbl,
1986: p_style_id_tbl => x_headers.style_id_tbl,

Line 1988: x_clm_standard_form_tbl => x_headers.clm_standard_form_tbl,

1984: p_key => l_key,
1985: p_index_tbl => l_index_tbl,
1986: p_style_id_tbl => x_headers.style_id_tbl,
1987: p_clm_award_type => x_headers.clm_award_type_tbl,
1988: x_clm_standard_form_tbl => x_headers.clm_standard_form_tbl,
1989: x_clm_document_format_tbl => x_headers.clm_document_format_tbl
1990: );
1991: END IF;
1992: --CLM PDOI Integration Ends

Line 2098: l_headers.clm_standard_form := x_headers.clm_standard_form_tbl;

2094: l_headers.approval_required_flag := x_headers.approval_required_flag_tbl;
2095: l_headers.style_id := x_headers.style_id_tbl;
2096:
2097: --PDOI CLM Integration
2098: l_headers.clm_standard_form := x_headers.clm_standard_form_tbl;
2099: l_headers.clm_document_format := x_headers.clm_document_format_tbl;
2100: l_headers.clm_award_type := x_headers.clm_award_type_tbl;
2101: l_headers.clm_source_document_id := x_headers.clm_source_document_id_tbl;
2102: l_headers.clm_award_administrator := x_headers.clm_award_administrator_tbl;

Line 3729: PROCEDURE default_clm_standard_format

3725:
3726:
3727:
3728: --PDOI CLM Integration Starts
3729: PROCEDURE default_clm_standard_format
3730: (
3731: p_key IN po_session_gt.key%TYPE,
3732: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3733: p_style_id_tbl IN PO_TBL_NUMBER,

Line 3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,

3731: p_key IN po_session_gt.key%TYPE,
3732: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3733: p_style_id_tbl IN PO_TBL_NUMBER,
3734: p_clm_award_type IN PO_TBL_VARCHAR30,
3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
3736: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
3737: ) IS
3738:
3739: d_api_name CONSTANT VARCHAR2(30) := 'deafult_clm_standard_format';

Line 3739: d_api_name CONSTANT VARCHAR2(30) := 'deafult_clm_standard_format';

3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
3736: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
3737: ) IS
3738:
3739: d_api_name CONSTANT VARCHAR2(30) := 'deafult_clm_standard_format';
3740: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3741: d_position NUMBER;
3742:
3743: -- tables to store the derived result

Line 3745: l_standard_form_tbl PO_TBL_VARCHAR30;

3741: d_position NUMBER;
3742:
3743: -- tables to store the derived result
3744: l_index_tbl PO_TBL_NUMBER;
3745: l_standard_form_tbl PO_TBL_VARCHAR30;
3746: l_document_format_tbl PO_TBL_VARCHAR30;
3747:
3748: BEGIN
3749: d_position := 0;

Line 3753: PO_LOG.proc_begin(d_module, 'clm_standard_form_tbl', x_clm_standard_form_tbl);

3749: d_position := 0;
3750:
3751: IF (PO_LOG.d_proc) THEN
3752: PO_LOG.proc_begin(d_module, 'style_id_tbl', p_style_id_tbl);
3753: PO_LOG.proc_begin(d_module, 'clm_standard_form_tbl', x_clm_standard_form_tbl);
3754: PO_LOG.proc_begin(d_module, 'clm_document_format_tbl', x_clm_document_format_tbl);
3755: END IF;
3756:
3757: FORALL i IN 1..p_index_tbl.COUNT

Line 3761: x_clm_standard_form_tbl(i),

3757: FORALL i IN 1..p_index_tbl.COUNT
3758: INSERT INTO po_session_gt(key, num1, char1, char2, char3, num2)
3759: SELECT p_key,
3760: p_index_tbl(i),
3761: x_clm_standard_form_tbl(i),
3762: x_clm_document_format_tbl(i),
3763: p_clm_award_type(i),
3764: p_style_id_tbl(i)
3765: FROM PO_DOC_STYLE_HEADERS

Line 3769: --Try to deafult both standard_from & document_format if there exists an entry of default type

3765: FROM PO_DOC_STYLE_HEADERS
3766: WHERE style_id = p_style_id_tbl(i)
3767: AND nvl(clm_flag, 'N') ='Y';
3768:
3769: --Try to deafult both standard_from & document_format if there exists an entry of default type
3770: FORALL i IN 1..p_index_tbl.COUNT
3771: UPDATE po_session_gt
3772: SET char1 = ( SELECT standard_form
3773: FROM PO_PRINT_FORM_FORMATS

Line 3772: SET char1 = ( SELECT standard_form

3768:
3769: --Try to deafult both standard_from & document_format if there exists an entry of default type
3770: FORALL i IN 1..p_index_tbl.COUNT
3771: UPDATE po_session_gt
3772: SET char1 = ( SELECT standard_form
3773: FROM PO_PRINT_FORM_FORMATS
3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3775: decode(char3,
3776: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',

Line 3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3770: FORALL i IN 1..p_index_tbl.COUNT
3771: UPDATE po_session_gt
3772: SET char1 = ( SELECT standard_form
3773: FROM PO_PRINT_FORM_FORMATS
3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3775: decode(char3,
3776: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3777: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3778: 'PO_AWARD_STD_FORM'),

Line 3787: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3783: ),
3784:
3785: char2 = ( SELECT document_format
3786: FROM PO_PRINT_FORM_FORMATS
3787: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3788: decode(char3,
3789: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3790: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3791: 'PO_AWARD_STD_FORM'),

Line 3803: --Try to default only the document_format from standard_form

3799: AND char2 IS NULL
3800: AND num1 = p_index_tbl(i);
3801:
3802:
3803: --Try to default only the document_format from standard_form
3804: FORALL i IN 1..p_index_tbl.COUNT
3805: UPDATE po_session_gt
3806: SET char2 = ( SELECT document_format
3807: FROM PO_PRINT_FORM_FORMATS

Line 3808: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3804: FORALL i IN 1..p_index_tbl.COUNT
3805: UPDATE po_session_gt
3806: SET char2 = ( SELECT document_format
3807: FROM PO_PRINT_FORM_FORMATS
3808: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3809: decode(char3,
3810: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3811: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3812: 'PO_AWARD_STD_FORM'),

Line 3814: AND standard_form = char1

3810: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3811: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3812: 'PO_AWARD_STD_FORM'),
3813: 'PO_IDV_STD_FORM')
3814: AND standard_form = char1
3815: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate +1))
3816: AND style_id = num2
3817: AND ( Nvl(default_flag,'N') = 'Y' OR 1 = (SELECT Count(document_format)
3818: FROM PO_PRINT_FORM_FORMATS

Line 3819: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3815: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate +1))
3816: AND style_id = num2
3817: AND ( Nvl(default_flag,'N') = 'Y' OR 1 = (SELECT Count(document_format)
3818: FROM PO_PRINT_FORM_FORMATS
3819: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3820: decode(char3,
3821: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3822: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3823: 'PO_AWARD_STD_FORM'),

Line 3825: AND standard_form = char1

3821: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3822: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3823: 'PO_AWARD_STD_FORM'),
3824: 'PO_IDV_STD_FORM')
3825: AND standard_form = char1
3826: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate +1))
3827: AND style_id = num2)
3828: )
3829: )

Line 3840: RETURNING num1, char1, char2 BULK COLLECT INTO l_index_tbl, l_standard_form_tbl, l_document_format_tbl ;

3836: d_position := 10;
3837:
3838: DELETE FROM po_session_gt
3839: WHERE key = p_key
3840: RETURNING num1, char1, char2 BULK COLLECT INTO l_index_tbl, l_standard_form_tbl, l_document_format_tbl ;
3841:
3842: d_position := 20;
3843:
3844: FOR i IN 1..l_index_tbl.COUNT

Line 3848: PO_LOG.stmt(d_module, d_position, 'new standard form', l_standard_form_tbl(i));

3844: FOR i IN 1..l_index_tbl.COUNT
3845: LOOP
3846: IF (PO_LOG.d_stmt) THEN
3847: PO_LOG.stmt(d_module, d_position, 'index', l_index_tbl(i));
3848: PO_LOG.stmt(d_module, d_position, 'new standard form', l_standard_form_tbl(i));
3849: PO_LOG.stmt(d_module, d_position, 'new document format', l_document_format_tbl(i));
3850: END IF;
3851:
3852: x_clm_standard_form_tbl(l_index_tbl(i)) := l_standard_form_tbl(i);

Line 3852: x_clm_standard_form_tbl(l_index_tbl(i)) := l_standard_form_tbl(i);

3848: PO_LOG.stmt(d_module, d_position, 'new standard form', l_standard_form_tbl(i));
3849: PO_LOG.stmt(d_module, d_position, 'new document format', l_document_format_tbl(i));
3850: END IF;
3851:
3852: x_clm_standard_form_tbl(l_index_tbl(i)) := l_standard_form_tbl(i);
3853: x_clm_document_format_tbl(l_index_tbl(i)) := l_document_format_tbl(i);
3854: END LOOP;
3855:
3856: IF (PO_LOG.d_proc) THEN

Line 3869: END default_clm_standard_format;

3865: p_procedure_name => d_api_name || '.' || d_position
3866: );
3867: RAISE;
3868:
3869: END default_clm_standard_format;
3870:
3871:
3872:
3873: PROCEDURE derive_clm_award_type

Line 4183: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;

4179: FROM po_headers_all
4180: WHERE x_vendor_id_tbl(i) IS NULL
4181: AND p_clm_source_document_id_tbl(i) IS NOT NULL
4182: AND po_header_id = p_clm_source_document_id_tbl(i)
4183: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;
4184:
4185: d_position := 10;
4186:
4187: DELETE FROM po_session_gt

Line 4251: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;

4247: FROM po_headers_all
4248: WHERE x_vendor_site_id_tbl(i) IS NULL
4249: AND p_clm_source_document_id_tbl(i) IS NOT NULL
4250: AND po_header_id = p_clm_source_document_id_tbl(i)
4251: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;
4252:
4253: d_position := 10;
4254:
4255: DELETE FROM po_session_gt