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.

[Home] [Help]

APPS.PSB_WORKFLOW_PVT dependencies on PSB_WS_DISTRIBUTIONS

Line 24: psb_ws_distributions.distribution_instructions%TYPE ;

20: g_current_user_id NUMBER ;
21: g_current_login_id NUMBER ;
22: --
23: g_distribution_instructions
24: psb_ws_distributions.distribution_instructions%TYPE ;
25:
26: /*-------------------- End Global variables ---------------------------*/
27:
28:

Line 93: l_worksheet_id psb_ws_distributions.worksheet_id%TYPE ;

89: l_return_status VARCHAR2(1) ;
90: l_msg_count NUMBER ;
91: l_msg_data VARCHAR2(2000) ;
92: --
93: l_worksheet_id psb_ws_distributions.worksheet_id%TYPE ;
94: l_created_worksheet_id psb_worksheets.worksheet_id%TYPE ;
95: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
96: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
97: l_distribution_rule_id psb_ws_distributions.distribution_rule_id%TYPE ;

Line 97: l_distribution_rule_id psb_ws_distributions.distribution_rule_id%TYPE ;

93: l_worksheet_id psb_ws_distributions.worksheet_id%TYPE ;
94: l_created_worksheet_id psb_worksheets.worksheet_id%TYPE ;
95: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
96: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
97: l_distribution_rule_id psb_ws_distributions.distribution_rule_id%TYPE ;
98: l_distribution_option_flag
99: psb_ws_distributions.distribution_option_flag%TYPE ;
100: --
101: l_export_name VARCHAR2(80);

Line 99: psb_ws_distributions.distribution_option_flag%TYPE ;

95: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
96: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
97: l_distribution_rule_id psb_ws_distributions.distribution_rule_id%TYPE ;
98: l_distribution_option_flag
99: psb_ws_distributions.distribution_option_flag%TYPE ;
100: --
101: l_export_name VARCHAR2(80);
102: --
103: BEGIN

Line 128: FROM psb_ws_distributions

124: l_worksheet_id ,
125: l_distribution_rule_id ,
126: g_distribution_instructions ,
127: l_distribution_option_flag
128: FROM psb_ws_distributions
129: WHERE distribution_id = p_distribution_id ;
130:
131: --
132: -- The Budget Revision functionality introduced the new flag called

Line 628: FROM psb_ws_distribution_details details, psb_ws_distributions distr

624:
625: /*
626: CURSOR l_child_worksheet_csr IS
627: SELECT child_worksheet_id
628: FROM psb_ws_distribution_details details, psb_ws_distributions distr
629: -- Bug No 2297742 Start
630: -- WHERE distr.worksheet_id = p_worksheet_id
631: WHERE distr.worksheet_id = details.worksheet_id
632: AND distr.distribution_id = p_distribution_id

Line 806: UPDATE psb_ws_distributions

802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
803: END IF;
804:
805: -- Update distributions table
806: UPDATE psb_ws_distributions
807: SET distribution_date = g_current_date,
808: distributed_flag = 'Y',
809: last_update_date = g_current_date,
810: last_updated_by = g_current_user_id,

Line 1173: FROM psb_ws_distributions

1169: INTO
1170: l_budget_revision_id ,
1171: l_distribution_rule_id ,
1172: g_distribution_instructions
1173: FROM psb_ws_distributions
1174: WHERE distribution_id = p_distribution_id
1175: AND distribution_option_flag = 'R'; --for budget revision
1176:
1177: --

Line 1351: FROM psb_ws_distribution_details details, psb_ws_distributions distr

1347: /*
1348: -- To find whether a budget revision been created for the budget group.
1349: CURSOR l_child_budget_rev_csr IS
1350: SELECT child_worksheet_id
1351: FROM psb_ws_distribution_details details, psb_ws_distributions distr
1352: WHERE distr.worksheet_id = p_budget_revision_id
1353: AND distr.distribution_id = p_distribution_id
1354: AND distr.distribution_option_flag = 'R'
1355: AND global_worksheet_id = p_global_budget_revision_id

Line 1361: FROM PSB_WS_DISTRIBUTIONS

1357: */
1358:
1359: CURSOR l_revision_option_csr IS
1360: SELECT revision_option_flag
1361: FROM PSB_WS_DISTRIBUTIONS
1362: WHERE distribution_id = p_distribution_id
1363: AND distribution_option_flag = 'R';
1364:
1365: -- Find the approver role name for the budget group.

Line 1539: UPDATE psb_ws_distributions

1535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1536: END IF;
1537:
1538: -- Update distributions table
1539: UPDATE psb_ws_distributions
1540: SET distribution_date = g_current_date,
1541: distributed_flag = 'Y',
1542: last_update_date = g_current_date,
1543: last_updated_by = g_current_user_id,