DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on AP_WORKFLOW_PKG

Line 1: PACKAGE BODY AP_WORKFLOW_PKG AS

1: PACKAGE BODY AP_WORKFLOW_PKG AS
2: /* $Header: aphanwfb.pls 120.96.12020000.11 2013/04/09 08:32:39 nbshaik ship $ */
3: --------------------------------------------------------------
4: -- Global Variables --
5: --------------------------------------------------------------

Line 8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP_WORKFLOW_PKG';

4: -- Global Variables --
5: --------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP_WORKFLOW_PKG';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:
11: -- Public Procedure Specifications
12:

Line 897: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';

893: --Now set the environment
894: MO_GLOBAL.INIT ('SQLAP');
895: MO_GLOBAL.set_policy_context('S',l_org_id);
896:
897: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
898: l_success := ap_etax_pkg.calling_etax(
899: p_invoice_id => l_invoice_id,
900: p_calling_mode => 'CALCULATE',
901: p_all_error_messages => 'N',

Line 1212: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';

1208: --Now set the environment
1209: MO_GLOBAL.INIT ('SQLAP');
1210: MO_GLOBAL.set_policy_context('S',l_org_id);
1211:
1212: l_curr_calling_sequence := 'ap_workflow_pkg.process_accept_ext';
1213: l_success := ap_etax_pkg.calling_etax(
1214: p_invoice_id => l_invoice_id,
1215: p_calling_mode => 'CALCULATE',
1216: p_all_error_messages => 'N',

Line 1582: 'AP_WORKFLOW_PKG.'|| l_api_name);

1578:
1579: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1580: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
1581: l_api_name,
1582: 'AP_WORKFLOW_PKG.'|| l_api_name);
1583: END IF;
1584:
1585: /*
1586: l_debug_info := 'set variables from workflow';

Line 1803: 'AP_WORKFLOW_PKG.'|| l_api_name);

1799: BEGIN
1800: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1802: G_MODULE_NAME||l_api_name,
1803: 'AP_WORKFLOW_PKG.'|| l_api_name);
1804: END IF;
1805: l_debug_info := l_api_name ||
1806: ': get variables from workflow: itemtype = ' ||
1807: itemtype ||

Line 2350: 'AP_WORKFLOW_PKG.'|| l_api_name);

2346:
2347: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2348: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2349: G_MODULE_NAME||l_api_name,
2350: 'AP_WORKFLOW_PKG.'|| l_api_name);
2351: END IF;
2352: l_debug_info := l_api_name ||
2353: ': get variables from workflow: itemtype = ' ||
2354: itemtype ||

Line 2641: 'AP_WORKFLOW_PKG.'|| l_api_name);

2637:
2638: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2639: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2640: G_MODULE_NAME||l_api_name,
2641: 'AP_WORKFLOW_PKG.'|| l_api_name);
2642: END IF;
2643: l_debug_info := l_api_name ||
2644: ': get variables from workflow: itemtype = ' ||
2645: itemtype ||

Line 3889: := 'AP_WORKFLOW_PKG.aprvl_process_accept_ext';

3885:
3886: BEGIN
3887:
3888: l_curr_calling_sequence
3889: := 'AP_WORKFLOW_PKG.aprvl_process_accept_ext';
3890: l_debug_info := 'Start';
3891: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3892: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3893: l_api_name,l_debug_info);

Line 4069: l_curr_calling_sequence := 'AP_WORKFLOW_PKG.aprvl_process_accept_int';

4065: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4066: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4067: l_api_name,l_debug_info);
4068: END IF;
4069: l_curr_calling_sequence := 'AP_WORKFLOW_PKG.aprvl_process_accept_int';
4070: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
4071: itemkey,
4072: 'INVOICE_ID');
4073:

Line 4959: 'ap_workflow_pkg.get_header_approver');

4955: p_invoice_id => l_invoice_id,
4956: p_terms_id => l_terms_id,
4957: p_terms_date => l_terms_date,
4958: p_calling_sequence =>
4959: 'ap_workflow_pkg.get_header_approver');
4960:
4961:
4962: UPDATE AP_INVOICES_ALL
4963: SET invoice_type_lookup_code =

Line 8938: AP_WORKFLOW_PKG.insert_history_table(p_hist_rec => l_hist_rec);

8934: l_hist_rec.APPROVER_NAME := l_display_name;
8935: l_comments := nvl(l_comments,'None');
8936: l_comments :='To: '||l_display_name||' '||' With Comment:'||l_comments;
8937: l_hist_rec.APPROVER_COMMENTS := l_comments;
8938: AP_WORKFLOW_PKG.insert_history_table(p_hist_rec => l_hist_rec);
8939: Elsif (Approvaltype = 'LINESAPPROVAL') Then
8940:
8941: l_hist_rec.HISTORY_TYPE := 'LINESAPPROVAL';
8942:

Line 9000: AP_WORKFLOW_PKG.insert_history_table(p_hist_rec => l_hist_rec);

8996: l_hist_rec.APPROVER_NAME := l_display_name;
8997: l_comments := nvl(l_comments,'None');
8998: l_comments :='To: '||l_display_name||' '||' With Comment:'||l_comments;
8999: l_hist_rec.APPROVER_COMMENTS := l_comments;
9000: AP_WORKFLOW_PKG.insert_history_table(p_hist_rec => l_hist_rec);
9001: END LOOP;
9002: CLOSE Items_Cur;
9003:
9004: END IF;

Line 9026: END AP_WORKFLOW_PKG;

9022: RAISE;
9023: END;
9024:
9025:
9026: END AP_WORKFLOW_PKG;