[Home] [Help]
21: );
22:
23: PROCEDURE init_ar_gt_tables;
24:
25: -- this function returns the standard tables used for AR Applications
26: -- if there is any change to the below function, please modify the
27: -- get_static_where_clause_ar_inv appropriately
28: FUNCTION get_std_table_list_ar_inv RETURN VARCHAR2;
29:
30: -- this function returns the static where clause for the tables listed
31: -- in get_std_table_list_ar_inv
32: FUNCTION get_static_where_clause_ar_inv RETURN VARCHAR2;
33:
34: -- this function returns the standard hint
35: -- when the tables mentioned at get_std_table_list_ar_inv are used
36: -- and the static where at get_static_where_clause_ar_inv is used
37: FUNCTION get_hint_ar_inv RETURN VARCHAR2;
38:
35: -- when the tables mentioned at get_std_table_list_ar_inv are used
36: -- and the static where at get_static_where_clause_ar_inv is used
37: FUNCTION get_hint_ar_inv RETURN VARCHAR2;
38:
39: -- this function returns the standard tables used for AR Applications
40: -- if there is any change to the below function, please modify the
41: -- get_static_where_clause_ar_app appropriately
42: FUNCTION get_std_table_list_ar_app RETURN VARCHAR2;
43:
44: -- this function returns the static where clause for the tables listed
45: -- in get_std_table_list_ar_app
46: FUNCTION get_static_where_clause_ar_app RETURN VARCHAR2;
47:
48: -- this function returns the standard hint
49: -- when the tables mentioned at get_std_table_list_ar_app are used
50: -- and the static where at get_static_where_clause_ar_app is used
51: FUNCTION get_hint_ar_app RETURN VARCHAR2;
52:
421: G_BATCH_DATE_HIGH DATE;
422: G_BATCH_SOURCE_ID VARCHAR2(30);
423: G_ADJUSTED_DOC_FROM VARCHAR2(30);
424: G_ADJUSTED_DOC_TO VARCHAR2(30);
425: G_STANDARD_VAT_TAX_RATE VARCHAR2(30);
426: G_MUNICIPAL_TAX VARCHAR2(30);
427: G_PROVINCIAL_TAX VARCHAR2(30);
428: G_TAX_ACCOUNT_LOW VARCHAR2(300);
429: G_TAX_ACCOUNT_HIGH VARCHAR2(300);
9241: G_BATCH_DATE_HIGH := P_TRL_GLOBAL_VARIABLES_REC.BATCH_DATE_HIGH;
9242: G_BATCH_SOURCE_ID := P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID;
9243: G_ADJUSTED_DOC_FROM := P_TRL_GLOBAL_VARIABLES_REC.ADJUSTED_DOC_FROM;
9244: G_ADJUSTED_DOC_TO := P_TRL_GLOBAL_VARIABLES_REC.ADJUSTED_DOC_TO;
9245: G_STANDARD_VAT_TAX_RATE := P_TRL_GLOBAL_VARIABLES_REC.STANDARD_VAT_TAX_RATE;
9246: G_MUNICIPAL_TAX := P_TRL_GLOBAL_VARIABLES_REC.MUNICIPAL_TAX;
9247: G_PROVINCIAL_TAX := P_TRL_GLOBAL_VARIABLES_REC.PROVINCIAL_TAX;
9248: G_TAX_ACCOUNT_LOW := P_TRL_GLOBAL_VARIABLES_REC.TAX_ACCOUNT_LOW;
9249: G_TAX_ACCOUNT_HIGH := P_TRL_GLOBAL_VARIABLES_REC.TAX_ACCOUNT_HIGH;
9303:
9304: END assign_ar_global_variables;
9305:
9306:
9307: -- this function returns the standard HINT used for AR
9308: FUNCTION get_hint_ar_inv RETURN VARCHAR2 IS
9309: BEGIN
9310: IF G_TRX_DATE_LOW IS NOT NULL AND G_TRX_DATE_HIGH IS NOT NULL THEN
9311: IF G_USE_PARALLEL_HINT = 'Y' THEN
9347: END IF;
9348:
9349: END get_hint_ar_inv;
9350:
9351: -- this function returns the standard tables used for AR
9352: -- if there is any change to the below function, please modify the
9353: -- get_static_where_clause_ar_inv appropriately
9354: FUNCTION get_std_table_list_ar_inv RETURN VARCHAR2 IS
9355: l_from_clause VARCHAR2(1000);
9400: END IF;
9401: RETURN l_where_clause;
9402: END get_static_where_clause_ar_inv;
9403:
9404: -- this function returns the standard HINT used for AR Applications
9405: FUNCTION get_hint_ar_app RETURN VARCHAR2 IS
9406: BEGIN
9407: IF g_first_party_tax_reg_num IS NOT NULL THEN
9408: RETURN ' /*+ leading (zx_tax,zx_rate) */ ';
9410: RETURN ' /*+ leading (zx_det,app) */ ';
9411: END IF;
9412: END get_hint_ar_app;
9413:
9414: -- this function returns the standard tables used for AR Applications
9415: -- if there is any change to the below function, please modify the
9416: -- get_static_where_clause_ar_app appropriately
9417: FUNCTION get_std_table_list_ar_app RETURN VARCHAR2 IS
9418: l_from_clause_app VARCHAR2(1000);